Creating a SQL Script in the Script Editor

Previous

Next

---

To create a new SQL script in the Script Editor:

1. On the Database Home Page, click the SQL icon.

2. Click the SQL Scripts icon.

   The SQL Scripts page appears.

3. Click the Create button.

   The Script Editor appears.

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

   Script name extensions are optional.

5. Enter the SQL statements, PL/SQL blocks and SQL Command Line (SQL*Plus) commands you want to include in your script.

   Remember that SQL Command Line commands are ignored at runtime.

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

   The SQL Scripts page appears listing your newly saved script.