Running SQL Statements on the SQL Commands Page

Previous

Next

To enter and run SQL statements in the SQL Commands page:

1. Log in to the Database Home Page. See "Logging in to the Database Home Page". To run the examples in this guide, log in as user HR with your password for the HR account.

2. On the Database Home Page, click the SQL icon to display the SQL page.

3. Click the SQL Commands icon to display the SQL Commands page.

4. On the SQL Commands page, enter the SQL statements in Example: Using the SQL SELECT Statement to Query All Data From a Table. Note that SQL statements are terminated with a semi colon (;) in the examples. The semi colon is required when running the SQL statements in a SQL script or at the SQL Command Line prompt, but it is optional on the SQL Commands page.

5. Select (highlight) the SQL statement that you want to run, then click Run to run the statement and display the results.

6. If you want to save the SQL statements for future use, click the Save button.

7. In the Name field, enter a name for the saved SQL statements. You can also enter an optional description. Click the Save button to save the SQL statement.

8. To access saved SQL statements, click the Saved SQL tab and select the name of the saved SQL statement that you want to access.