Executing a SQL Script in the Script Editor

Previous

Next

---

To execute a script in the Script Editor:

1. Open the script you want to execute in the Script Editor. See "Using the Script Editor".

2. Click Run in the Script Editor.

3. 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 Command Line (SQL*Plus) commands that will be ignored when the script is executed.

   The Run Script page has three controls:

   • Cancel returns you to the SQL Scripts page without executing the script.

   • Edit Script loads the script into the Script Editor. Note that Edit Script appears instead of Run when a script has errors.

   • Run to submit the script for execution. Note that Run is not available if there are script errors.

4. Click Run to submit the script for execution.

   The Manage Script Results page appears listing script results.

5. To view script results, click the View icon under View Results.