Displaying Results

When you execute a SQL command, the results are displayed. The results of the last executed command are available until you execute another SQL command, or leave the SQL Command Processor.

To display SQL command results:

Click the SQL Workshop icon on the Workspace home page.
Click the SQL Commands icon.
Click the Results tab which is located between the command editor and the display pane.

The HTML formatted results appear in the display pane.
Click DBMS Output to display plain text DBMS output results.

The DBMS Output control only appears if there is DBMS output in addition to HTML formatted results. It does not appear if there is only DBMS output, or if there is only HTML formatted output.

About the Results Pane

The Results pane displays SQL command results as HTML formatted table. The number of rows returned appears at the end of the output, and the time taken. DBMS output appears as plain text after the HTML formatted results.

On the Results pane you can:

Display DBMS output. Click DBMS Output at the bottom of the displayed results to display lines of DBMS output. This control only appears when there is DBMS output to display.
Export results. Click CSV Export to export results to a comma separated file on your local file system. You are prompted to enter a name and directory for the file.