Viewing SQL Results

Results from running any of the procedural objects, SQL files, or execution of selected SQL statements appear in SQL Results. SQL Results displays:

Status: Shows if 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 Result Set was displayed.
Status Detail: Shows the interim status of running the procedural object.
Multiple Result Sets: Displays multiple query results, where each result corresponds to a SQL query in the procedural object, SQL file, or selected statements.
Messages: Contains messages from the database server, such as the output of a SQL print statement.

Available buttons in the SQL Results view include:

Terminate Result (square): click this button to terminate a long-running instance.
Remove Result (the single X button): click this button to remove the status, result sets, messages of a selected SQL result instance.
Remove All Results (the XX button): click this button to remove all results in the SQL Results view.