Category Archives: Oracle

Oracle SQL Developer 2.1

Posted on October 14, 2009 by Arun

I installed Oracle SQL Developer 2.1 Early Adapter release and it seems to load faster than the current stable version (1.5.x). SQL Developer, for it’s feature set or lack of that, takes more time to load in my system than … Continue reading →

Posted in Oracle | Tagged , , | Leave a comment

Running Oracle E-Business suite in Ubuntu Linux

Posted on October 1, 2009 by Arun

When we were using Oracle Jinitiator to access Oracle E-Business suite application, I couldn’t get it to work in Linux. I tried several suggestions, but nothing worked. We finally moved to Sun Java JRE from Jinitiator. That helped a lot … Continue reading →

Posted in Linux, Oracle, Ubuntu | Tagged , , , , | 18 Comments

Oracle SQL Developer pain

Posted on June 3, 2009 by Arun

I like Oracle SQL Developer even though it’s slightly bulkier and slower to start than Toad (with less functionality and buggy). I found one annoying problem with SQL Developer. If you are running a query in the SQL Worksheet and … Continue reading →

Posted in Oracle | Tagged , , , | 1 Comment

Oracle SQL Developer – Backspace, CTRL, Delete keys not working

Posted on May 20, 2009 by Arun

I use SQL Developers for my development work. All of a sudden, the Backspace key, CTRL key, Delete key and other function keys stopped working in the SQL worksheet. I don’t remember doing anything out of ordinary, but those keys … Continue reading →

Posted in Oracle | Tagged , , , | 17 Comments

Oracle SQL to get fiscal year dates

Posted on April 16, 2009 by Arun

I wanted to find out the fiscal year, fiscal year start date and fiscal year end date for a given date. Our fiscal year runs from July 01st to June 30th. We’re on fiscal year 09 now starting from 01st … Continue reading →

Posted in Oracle | Tagged , , , | Leave a comment

Ora_Tweet – Tweet from Oracle database using PLSQL

Posted on April 10, 2009 by Arun

Ora_tweet is a PL/SQL Twitter API that can be used to send messages from your Oracle database to your twitter account. It might come handy for DBAs who twitters a lot. This is the first version and all it does … Continue reading →

Posted in Oracle | Tagged , , , | Leave a comment

Firefox 3.0 finally certified with Oracle E-Business suite

Posted on March 2, 2009 by Arun

More than 8 months after Firefox 3.0 was released and Firefox 3.1 getting close to final release, Oracle has certified Firefox 3.0 with Oracle E-Business suite 11i and 12. They have released a new ATG interoperability patch to support Firefox … Continue reading →

Posted in Oracle, Technology | Tagged , , , | Leave a comment

Oracle SQL – Converting multiple rows into single row

Posted on February 23, 2009 by Arun

One of the project I’m working on has a requirement where if an employee has multiple assignments (multiple rows in the assignment table), then the SQL should consolidate his assignments into one row, with each column holding multiple values (for … Continue reading →

Posted in Oracle, Technology | Tagged , , , , , | 15 Comments

Offending Oracle’s E-Business Suite Report

Posted on December 10, 2008 by Arun

Our HR department ran one of Oracle’s E-Business Suite report which reports on new hires. This is what we found in the log file of the report. MSG-00001: tmp011: MSG-00088: Hell with this MSG-00001: hello MSG-00088: Hell with this MSG-00001: … Continue reading →

Posted in General, Oracle | Tagged , | Leave a comment

SQL Developer 1.5 connection setting lost

Posted on May 12, 2008 by Arun

If you work with Oracle Database, then you might have heard about SQL Developer. SQL Developer is a free graphical tool for database development. I use this for some of my Oracle work. It’s a decent tool and it’s free. … Continue reading →

Posted in General, Oracle | Tagged , , , , , , | 19 Comments