conversion differences between TO_NUMBER and TO_CHAR

It was interesting to note that what works in TO_CHAR conversion does not in TO_NUMBER. For TO_CHAR, I passed 12.56 for parameter1 and '999.9' for parameter2. It returned 12.6(has obviously rounded it up. Whereas, try it for TO_NUMBER, ORACLE returned an error ORA-01722

PLSQL & SQL Guidelines

Trivadis has taken considerable time and effort to publish a PLSQL and SQL Guidelines. Very organized and well laid out. It also earned a foreward from Steven Feurerstein. To read /download goto their website: http://www.trivadis.com/fileadmin/user_upload/email4download_Pflicht/TVD_PLSQLSQLCodingGuide.pdf

Companies are Adding Jobs. Are you ready?

Interesting Post by Dice.com.

SQL Developer History

SQL Developer History

History of commands is handled very well in SQLDeveloper. Pressing F8 will display the history of sql commands that has been issued till now. Place the cursor in the SQL Window, and press "Ctrl+Up arrow" or "Ctrl + down arrow", to paste commands in the history tab into the SQL Window. This works very well, except for the last row or the first row, when the up or down arrow will takes me nowhere. For either of these two situations, I either grab the SQL, from the History window, with cursor and drop it in the SQL Window; or, go down/up a row in the History window and press the "Ctrl+Up" or Ctrl+dwn" key.