6.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.

6.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.

   Note:

   SQLcl commands are ignored at runtime.
5. Click Create.
   The SQL Scripts page appears listing your newly saved script.

6.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 SQLcl 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