Saturday, April 17, 2010

Drag & Drop to create query

SQLDeveloper keeps amazing me. I can easily create a query by merely selecting columns I need on the left pane and drop it in the SQL Window to create a query. Here are the steps I followed to create a query
(I have already created a connection and been able to successfully connect to SQLDeveloper, organized the logins into folders). The initial screen will look like Screen -1


Open a New SQLWorkSheet by clicking on the SQL ICON (Screen-2)


A popup window will open up (Screen -3)

Select the columns you need (either by pressing SHIFT and Left Mouse Click or (as I did) CTRL+ Left Mouse click) and drag them into the SQL Window (Screen -4)

result is displayed as shown in Screen -5.


Bug-01: There is a minor bug in this version (2.1.1.64). Let us say there is a query already existing the query window like above. You click on the left pane to select a few columns; Drag them into SQL Window and a popup window appears, where you would have to choose amongst "Insert/Delete..." and after making your selections, instead of clicking on apply, you change your mind and click on "cancel", the query still gets copied to the SQL Window (Screen-6a, Screen-6b)


Note: This does not happen if there is no query in the SQL Window
Bug-02: Selecting "Join" has no effect.
SQLDeveloper is an excellent product. Would like to see it even better.

goosh.org

Goosh.org is a Open Source Command line search utility created by Stephan (to learn about him goto http://posterous.com/people/3zFYfHr9U ). Returns 4 results at a time. If you are interested to give it a look goto http://www.goosh.org/ )

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.