Viewing SQL Results

Results from running any of the procedural objects or SQL files, execution of selected SQL statements, and creating databases, appear in the SQL Results view. SQL Results displays a History frame and a Results frame. The SQL Results view is visible by default in the Database Development and Database Debug perspectives.

SQL Results History, on the left side, lists summary information on statements executed in the current session, including:

SQL Results History fields

Field	Explanation
Status	Displays whether the operation failed, succeeded, terminated, or is still running
Operation	Displays the SQL statement that was executed
Date	Displays the current date and time when the SQL statement or procedural object failed, completed execution, terminated, or reached a breakpoint

Results, on the right, shows details of the current statement, or the statement selected in History.

In single-tab mode, all results and messages appear in the same column, with messages and status at the end.
In multitab mode, each result and message is in a separate tab.

SQL Results detail tabs for multitab mode

Tab	Explanation
Status	Shows the interim status of running the procedural object or selected text
Resultn	Displays results for a SQL query in the procedural object, SQL file, or selected statement
Messagen	Contains messages from the database server, such as the output of a SQL print statement

A drop-down menu lets you filter history results, set preferences for SQL Results view and export format, and Save or Export one or all result sets in the current instance.

Action buttons on the SQL Results view toolbar include:

Button graphic	Button name	Action
	Terminate Result	Terminate a long-running instance.
	Remove Result	Remove the status, result sets, and messages of a selected SQL result instance.
	Remove All Finished Results	Remove all results for completed statements from the SQL Results view.
	Display the Result in Text Mode	Toggle between text mode and grid mode.
	Display the Result in Single Tab	Toggle between single-tab and multitab display.
	Save the Current Result Set	Open the Save Result dialog and save this result set to a file in a WorkSpace project. For operations with multiple result sets, you must be in multitab mode or in grid mode.
	Save all Result Sets	Open the Save All Results dialog and save all results for this operation to a file in a WorkSpace project.
	Export Single Result	Open the Export Result dialog and export this result set to a file outside the Eclipse WorkSpace. For operations with multiple result sets, you must be in multitab mode or grid mode.
	Export All Results	Open the Export All Results dialog and export all results for this operation to a file outside the Eclipse WorkSpace.