|
Oracle® HTML DB
Release 2.0 |
|
 Previous |
 Next |
To access the SQL Command Processor:
Log in to Oracle HTML DB.
The Workspace home page appears.
To view the SQL Command Processor home page you can either:
Click the SQL Workshop icon and then the SQL Commands icon to drill-down to the SQL Command Processor home page.
Click the down arrow on the right side of the SQL Workshop icon to view a pull-down menu. Then select the SQL Commands menu option.
|
Note: For the purposes of consistency, this document uses the primary navigation path (or drill-down approach) when explaining navigation. |
The SQL Command Processor 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:
Choose the schema. Make a selection from the Schema list to specify the schema in which to execute the command.
Disable transactional commands. If available, click the Autocommit check box to enable autocommit and disable transactional commands. The Autocommit check box is only available if transactional SQL commands are enabled for this HTML DB instance.
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 (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.
|
See Also: "About Transactions in the SQL Command Processor" and "Configuring SQL Workshop" for information about enabling the Autocommit check box |
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.
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.
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.