Tag 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

Going to Vegas for OHUG conference

Posted on June 12, 2009 by Arun

I’ll be going to Las Vegas to attend the OHUG conference from Sunday, June 14th to Thursday, June 18th.  I’ll blog when I get time.

Posted in General | Tagged , , | 1 Comment

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

What’s going to happen to MySQL?

Posted on April 21, 2009 by Arun

Now that Oracle has bought Sun Microsystem, what is going to happen to MySQL? Are they going to leave it as it is (as open source and free) to cover the small businesses or are they going to scrap it … Continue reading →

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

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