5.5 Creating a SQL Script

Learn about different ways of creating a SQL script.

You can create a script in the Script Repository by:

• Creating a SQL Script in the Script Editor
  Learn how to create SQL script in the Script Editor.
• Uploading a SQL Script
  Learn how to upload a SQL script from your local file system.

5.5.1 Creating a SQL Script in the Script Editor

Learn how to create 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. In Script Name, enter a name for the script. Script name extensions are optional.
4. Enter the SQL statements, PL/SQL blocks you want to include in your script.

   Remember that SQL*Plus commands are ignored at runtime.

5. Click Create.

   The SQL Scripts page appears listing your newly saved script.

5.5.2 Uploading a SQL Script

Learn how to upload a SQL script from your local file system.

To upload a script from your local file system:

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

   The SQL Scripts page appears.

2. Click the Upload button.

   The Upload Script dialog appears.

3. For Upload Script:

   1. File - Browse to locate the script you want to upload.

   2. Script Name - Optionally enter a new name in the Script Name field. This name displays in the Script Repository.

   3. File Character Set - Select the character set in which the script is encoded.

   4. Click Upload.

   The SQL Scripts page appears listing your newly uploaded script.

Tip:

The script is parsed during runtime. When parsed, ignored statements such as SQL*PLUS commands are listed. Any invalid SQL is identified only in results. If a script of the same name exists, you are prompted to rename it.

See Also:

"Creating a SQL Script in the Script Editor"