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.

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.

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