Statement Details pane

The Statement Details pane contains statistics and details generated from the selected statement in the Statement List pane. You can use these details for reference only. The pane has no interactive functionality. Statistics appear only for statements that are loaded from the Statement pane.

The following table describes the fields that appear in the Execution Results tab when a statement executes successfully.

Execution Results fields

Field or button

Function

Last Evaluated

Indicates when the statement was last evaluated.

Query Execution Time

Indicates the time taken to execute the query.

Status

Displays the executed statement status. The status indicates whether the statement was executed successfully or whether the statement was canceled.

Next Page

Displays the next set of execution results when the statement execution happens in the page mode. For more information on the page mode, see Page mode.

For DML statements such as INSERT, DELETE, and UPDATE, the results indicate how many rows were affected if the execution is successful. For other SQL commands, the results appear in text form.

For SELECT statements, you can use the Copy options to copy the results to a file, clipboard, or a spreadsheet. The copy options are Data to Clipboard, Data to Browser, Data to Spreadsheet, and Data to File. The data is preserved only while the SQL Whiteboard remains open. The data is flushed when the SQL Whiteboard is closed. Also, when in the page mode, you can copy data in the current page only.

The following table describes the tabs.

Statement Details tabs

Tab

Function

Execution Error

Displays the statement execution error.

Execution Parameters

Displays values set for the current or earlier execution. The Execution Parameters tab is displayed only if the statement has parameters.

Executed Statement

Displays the statement that was executed with the parameters (if any), replaced with their values.

For more information on the page mode, see Page mode.