You can create a script in the Script Repository by:
Creating a script in the Script Editor
Uploading a script from your local file system
Topics:
To create an SQL script in the Script Editor:
On the Workspace home page, click SQL Workshop and then SQL Scripts.
The SQL Scripts page appears.
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 you want to include in your script.
Remember that SQL*Plus commands are ignored at runtime.
Click Save to save your script to the repository.
The SQL Scripts page appears listing your newly saved script.
To upload a script from your local file system:
On the Workspace home page, click SQL Workshop and then SQL Scripts.
The SQL Scripts page appears.
Click the Upload button.
The Upload Script dialog appears.
Use Choose File button to select 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 page appears listing your newly uploaded script.
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 in the Script Repository, you are prompted to rename it.