Executing a SQL Script from the SQL Scripts Page

To execute a script from the SQL Scripts page:

1. On the Workspace home page, click SQL Workshop and then SQL Scripts.

   The SQL Scripts page appears.

2. From the View list, select Details and click Go.

   Details view appears.

3. Click the Run icon for the script you want to execute. The Run icon is located on the far right side adjacent to the script name.

4. The Run Script page appears.

   The Run Script page displays information about the script and lists statements in error preventing execution, or statements such as SQL*Plus commands that are ignored when the script is executed. The Run Script page has three controls:

   Cancel to return to the SQL Scripts page without executing the script.

   Edit Script to load the script into the Script Editor. Edit Script appears instead of Run when a script has errors.

   Run to submit the script for execution. Run is not available for scripts with errors.

5. Click Run to submit the script for execution.

   The Manage Script Results page appears listing available results for the script.

6. Click the View icon for the results you want to view. The View icon is at the right end of the scripts listed in the Manage Script Results page.