Tag Archives: Oracle

Oracle SQL Developer 2.1

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

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

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

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?

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

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

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

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

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

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