Viewing SQL Results

Use the SQL Results view to see the results of an executed SQL query or routine procedural object.

  1. Execute your SQL query, code to create a database object, or a routine procedural object.
  2. Examine the execution results in SQL Results view.
    • View the status of the query or object, the text of the query, the date and time, and error or informational messages.
    • Search result sets using standard Eclipse Find/Replace functionality.
    • Save a group (SQL statement, its children statements, and all their execution results) to a log file.
    • Display or save all SQL results in a file similar to iSQL command output.

    Note: The maximum number of result tabs that display is determined via the SQL Results view preference page. Any result sets that exceed the maximum number do not display. To view more result tabs, increase the limit. To view all results, export all results to a file and view the results in an external editor.
Related concepts
Procedural Routine Objects
SQL Results View
Related tasks
Executing a SQL File
Executing a SQL Statement
Running an Ad Hoc SQL Statement
Running a Routine Object
Creating a Launch Configuration for Routine Procedural Objects
Terminating Execution in SQL Results View
Exporting SQL Execution Results
Saving Execution Results to a Project
Removing Results from SQL Results View
Saving SQL Results History
Filtering SQL Results History
Related reference
SQL Results View Options Preferences
Export Format Options Preferences
History Options Preferences
Result Set Viewer Preferences