3.3 About the SQL Commands Home Page

Learn about the SQL commands home page.

The SQL Commands home page is divided into two sections: a command editor and a display pane. You use the command editor to execute SQL commands and the display pane to view output, saved command lists, and history lists.

The top of the SQL Commands home page features a command editor and the following controls:

  • Autocommit. If available, click the Autocommit check box to enable autocommit and disable transactional commands.

  • Rows. Select the number of rows of output to display simultaneously up to a maximum of 100,000. All rows of DBMS Output are displayed regardless of the Display list setting.

  • Clear Command. Use the Clear Command button to clear the text in the command editor.

  • Find Tables. Use the Find Tables button to view tables within the currently selected schema.

  • Save. Click the Save button to save the contents of the command editor, or the currently highlighted content to a file. You are prompted to enter a name and an optional description. The command appears in the Saved SQL list.

  • Run. Click the Run button (Ctrl+Enter) to run the command in the command editor, or the currently highlighted command in the command editor.

The display pane is at the bottom of the SQL Commands home page and features the following five tabs:

  • Results. Click the Results tab to see the results from the last successfully executed SQL command. 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. Click Download to export results to a comma-delimited file on your local file system.

  • Explain. Click the Explain tab to examine the execution plan used by the optimizer for statements that make changes to the database. Objects in the output are linked to the Object Browser. Click the linked object to view its properties in the Object Browser.

  • Describe. Enter Describe object_name and click Run to display column definitions for a table or view, or specifications for a function or procedure in the Describe tab. Select links in the Describe results to write that information into the command editor. For example, click a table name to add owner.table, click a column name to add the column name, click a procedure or function name to add the object call with parameters, or click a package name to add the package call.

  • Saved SQL. Click the Saved SQL tab to display a list of all SQL commands saved in the current workspace. Click the command title to load it into the command editor.

  • History. Click the History tab to list your recently executed commands. Your last 200 executed commands are saved.