Powerful SQL Editor

You can edit and execute SQL statements, and scripts containing multiple statements, in the SQL Editor. You can submit any SQL statement, including DML and DDL statements. When a SELECT statement is executed, the rows returned are displayed as a grid, and can be output as text to the Spool window.

The SQL window and the results display

$image\Sqln0190.gif$

$image\btn_More_about_the_SQL_editing_window60.gif$

$image\btn_More_about_the_Execution_Status_pane60.gif$

$image\btn_More_about_the_results_display28.gif$

$image\btn_More_about_updateable_queries96.gif$

$image\btn_More_about_working_with_query_results60.gif$

Code markers

$image\Sqln0191.gif$

$image\btn_More_about_code_markers96.gif$

The Spool Output window

$image\Sqln0192.gif$

Result Display

The output of every SQL statement executed can be displayed in a resizable Result area. You can set preferences that control how the results are displayed; for example:

$image\Sqln0004.gif$ In the lower pane of a split editing window

$image\Sqln0004.gif$ On separate tabbed pages

There can be multiple results displays, one per statement executed.

$image\btn_More_about_working_with_query_results60.gif$