Using the SQL Worksheet

Use the SQL Worksheet to:

To open the SQL Worksheet:

Select View | Connection Navigator .
Expand Database and select a database connection.
Right-click the connection in the Navigator, and choose SQL Worksheet from the context menu.

The SQL Worksheet has two panes:

SQL statements are entered into the upper pane.
Results from code execution are displayed in the lower pane.

Code Insight and the SQL Worksheet

The SQL Worksheet provides code insight for SQL code. When you type a name followed by a '.', a dropdown menu of valid code appears. The menu will contain:

Names of subprograms, if a package name plus '.' is entered.
Names of columns, if a table name plus '.' is entered.
Names of all database objects, if another name plus '.' is entered.

To configure Code Insight for the SQL Worksheet:

Select Tools | Preferences | Code Editor | Code Insight.
In the Code Insight page, adjust font size or font type, and completion insight and parameter insight timing.
Click OK. Your changes are active the next time you use the Code Editor.