Custom Date Format for Oracle SQL Developer

By default the SQL Developer only display the data in Date-Month-Year format. If you would like to change the output it is fairly easy.

Goto Tools -> Preference and Look for Database tree and expand it and select NLS.
For e.g.  DD-MM-RR HH24:MI:SS will give me a result as 31-MAY-11 14:01:12

Toad - Can't Find Oracle Client ( Win7 64bit)

Today I've encounter a quite a funny issue with the Toad 9 client. As usual the programmers folks would be doing their own development software.

Seems the Toad 9 is showing error Unable to locate Oracle Home. Path & TNS Admin have been added in the system variable. The error seems still coming :)

A few search on the internet suggesting to add in the ORACLE_HOME & ORACLE_PATH in the system variable but on works.

Currently we are using Instant Client 11_2 fo 64bit Windows. As some suggest since the Toad 9 is a 32bit software the instant client should be a 32bit as well, I change the instant client 11_2 to a 32bit version and it still wouldn't work.

Just to give it a try I load in the version 10_2 32bit Instant Client and viola it work like charm !