The SQL Scratchpad Result Panel
The Result panel appears in the bottom area of the SQL Scratchpad editor when you click the Execute button on the toolbar. The Result panel displays up to 50 lines of execution results. If more than 50 lines were returned, you can see more of them by clicking the Load More Results button.
The table below describes the buttons and the actions you can perform in the Result panel toolbar. The Cancel button appears in the Result panel during execution of long queries, letting you halt execution. When you close the Result panel, any query execution in progress is canceled.
You can dismiss the Result panel by clicking the Delete button on its tab.
Label | Use to... |
Save To File | Open a dialog box to save the results as a file. The default file type is a comma-separated values file (*.csv). |
Details | Open a Result Details window that lists all of the column headings and values for the selected row. Click Next to list details for the next row, or Prev to list details for the previous row. To dismiss the window, click OK. |
Load More Results | Load the next rows (up to 50) of the result. If 50 or fewer results were returned, this button is dimmed. |
Clear | Clear all results from the Result panel. |
Show Execution Plan | Open a tab, next to the Result tab, that shows the execution plan for the SQL executed. |
If you click Show Execution Plan on the Result tab, an Execution Plan opens adjacent to the Results tab. The Execution Plan tab shows the execution plan and details for the SQL executed. The execution ID is shown on both tabs, so that the two can be correlated. An Execution Plan tab to the left of a Result tab indicates a stale plan.