Running PL/SQL Code in the SQL Commands Page

Previous

Next

To enter and run PL/SQL code in the SQL Commands page:

1. Log in to the Database Home Page. See "Logging in to the Database Home Page".

2. On the 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 PL/SQL code in Example: Using a Simple PL/SQL Block. Note that some of the lines of code are terminated with a semi colon (;) and the entire code unit is terminated with a slash (/). The slash is required when running the PL/SQL in a SQL script or at the SQL Command Line prompt, but it is optional on the SQL Commands page.

5. Click the Run button to run the PL/SQL code. If necessary, select (highlight) only the PL/SQL code block before clicking the Run button. Any comments outside the PL/SQL code block are not legal in the SQL Commands page.

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

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

8. To access saved PL/SQL code, click the Saved SQL tab, and select the name of the saved PL/SQL code that you want to access.