Project Script Files

In the Oracle Database Project, script file project items represent Oracle SQL scripts.

When source control is enabled, the Menu Options also contain applicable source control operations.

Menu Options

Menu Item Description
Open Edits the item in the Oracle SQL editor.
Open With Edits the item in the editor that the user selects.
Run Runs the script using the default database reference. If there is no default database reference, then Run works the same as Run On. The results appear in the Output Pane. If there is a currently running script, then this menu item does not appear.
Run On Prompts the user for a database reference, then runs the script. The results appear in the Output Pane. If there is a currently running script, then this menu item does not appear.
Cancel Cancels the currently running script. If there is no script currently running, then this menu item does not appear.
Cut Copies selected script to the clipboard and prepares the script to be removed after a paste operation.
Copy Copies the script.
Remove

Deletes the script file. If the script is open in an editor, then you are given the following options:

  • Yes: to close the editor, and delete the script.

  • No: to keep the editor open and not delete the script. If multiple scripts are being deleted, then the operation proceeds to the next script after you select Yes or No.

  • Cancel: to abort the operation. Any scripts that have already been deleted remain deleted.

Rename Renames the script file
Properties Displays the properties window

Properties

Property Name Description
Name The file name (without path).
File name The file name including the full path.
Last Modified The last modified time of the file.

See Also Adding New Scripts|Adding Existing Scripts | Adding Automatically Generated Scripts for Schema Objects | Editing Script Files | Launching the Oracle SQL Script Editor | | Running a Script from Oracle Database Project