Creating a SQL Script

You can create a new script in the Script Repository by:

Topics:

Creating a SQL Script in the Script Editor

To create a new SQL script in the Script Editor:

Click the SQL Workshop icon on the Workspace home page.
Click the SQL Scripts icon.
Click the Create button.

The Script Editor appears.
Enter a name for the script in the Script Name field.

Script name extensions are optional.
Enter the SQL statements, PL/SQL blocks and SQL*Plus commands you want to include in your script.

SQL*Plus commands are ignored at runtime.
Click Save to save your script to the repository.

The SQL Scripts home page appears listing your newly saved script.

To upload a script from your local file system:

Click the SQL Workshop icon on the Workspace home page.
Click the SQL Scripts icon.
Click the Upload button.

The Upload Script dialog appears.
Enter the name and path to the script you want to upload to the Script Repository,

or

click Browse to locate the script you want to upload.
Optionally rename the script by entering the new name in the Script Name field.

This is the name given to the script in the Script Repository.
Click Upload to add the script to the Script Repository.

The SQL Scripts home page appears listing your newly uploaded script.

The script is parsed during upload. If it has a syntax error, an error icon appears in place of the run icon in the SQL Scripts home page Details view.

If a script of the same name exists in the Script Repository, you are prompted to rename it.