This tool lets you execute SQL expressions that reference table or views in the user's connected schema.
SQL Worksheet has two horizontal panes:
Standard Microsoft Windows clipboard operations are allowed in either pane. Select the desired text; then use Control+C to copy, Control+V to paste, or Control+X to cut.
You can also view SQL History, that is, a list of the SQL statements created during the current session.
Use File | Close to close SQL Worksheet
Type one or more SQL statements in the Enter SQL Statement (top) pane. These statements must contain tables and views in the connected user's schema.
To execute a statement, select it (click it) and do one of the following:
Results of the query, including error messages or statement execution status, are displayed in the Results pane. If the query generates a result set (attributes and their values), the result set is displayed in a grid. For details, see Results.
The Results pane displays the results of an executed query; the first 100 rows are displayed by default. You can change this default to any integer value by just highlighting the value of Fetch Size and typing the new value. Click Fetch Next fetch the next collection of rows. Click Refresh to display the first collection of rows in the result set after you change the Fetch Size.
To see a list of the SQL statements executed during the current SQL Worksheet session do one of the following:
The SQL History List is displayed. You can use a filter to help find a query. Any SQL statement selected in the history list replaces the contents of the SQL editor.
Copyright © 2006, 2008, Oracle. All rights reserved.