Creating a SQL Script in the Script Editor

To create an SQL script in the Script Editor:

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

   The SQL Scripts page appears.

2. Click the Create button.

   The Script Editor appears.

3. Enter a name for the script in the Script Name field.

   Script name extensions are optional.

4. Enter the SQL statements, PL/SQL blocks and SQL*Plus commands you want to include in your script.

   Remember that SQL Command Line commands are ignored at run time.

5. Click Save to save your script to the repository.

   The SQL Scripts page appears listing your newly saved script.