About the SQL Commands Home Page

Previous

Next

---

The SQL Commands home page contains a command editor and a display pane. You enter and edit SQL commands in the editor and view output, saved command lists, and history lists in the display pane.

On the SQL Commands home page you can:

• Disable transactional commands. If available, click the Autocommit check box to enable autocommit and disable transactional commands. See "About Transactions in SQL Commands".

• Set the number of output rows. Make a selection from the Display list to specify the number of rows of output to display at one time up to a maximum of 100,000. All rows of DBMS Output are displayed regardless of the Display list setting.

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

• Execute a SQL command. Click Run (or press Ctrl+Enter) to run the command in the editor, or the currently highlighted command in the editor.

• Highlight an individual statement for execution. Select an individual statement in the editor and click Run (or press Ctrl+Enter) to execute only the highlighted statement.

  The bottom of the SQL Commands home page features 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 CSV Export to export results to a comma separated file on your local file system. See "Viewing Results".

  • 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. See "Using Explain Plan".

  • 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 database user account. Click the command title to load it into the command editor. See "Using Saved Commands"

  • History. Click the History tab to list your recently executed commands. Your last 200 executed commands are saved. See "Using SQL Command History".