Friday, 14 January 2011

Clicking around the worksheet

As we have been getting close to another EA release, one thing which struck me as pretty cool and something we haven't talked about in a while are the click actions in the worksheet.

Looking at the image on the right, we can see the first action that is available. By holding the down while we move the mouse over the table employees we can see that it is highlighted and underlined. If we click on this, it will open up the appropriate editor.

Next we can see the list of SQL*Plus files below the query in the worksheet. Normally, these are written by locating the file and putting the appropriate syntax in place.

Well to make reviewing this files easier, we've added a similar functionality to these files. This way when we click on a file call, and the file exists, we can open that in an editor for reviewing and editing.

There are three places where we will look for files. The first is straight forward and is the complete file path name.


The second is taking files in your ORACLE_HOME directory and the '?' directive denotes that directory. so a typical directory looks like this.


Finally, the last one, has the format:


This last file structure takes the file from the USER_HOME directory in SQL Developer or, the place where you ran a script, or if you have the script directory set in the worksheet preferences, it will look there.

This will be available in our next EA, EA3.

No comments: