Oracle Database Project Folders

The default Oracle Database Project folders are named for Oracle schema types, for example, the Tables folder contains scripts to create database tables. You can rename, or delete the default folders or add your own folders. You can also drag and drop scripts from one folder to another.

When source control is enabled, folder menus also provide applicable source control operations.

To perform actions on a Oracle Database Project folder node, right-click the node and from the menu choose the appropriate command. To view the node's properties, select the node and/or click Properties in the nodes menu.

This section contains these topics:

Menu Options

Menu Option Description

Add New Item

Opens the Add New Item dialog box to add a new script to the project. See Adding New Scripts

Add Existing Item

Opens the Add Existing Item dialog box to add an existing item to the project. See Adding Existing Scripts

Add SQL Script

Opens the Add New Item dialog box.

New Folder

Creates a new folder.

Cut

Copies selected folder to the clipboard and prepares the folder to be removed after a paste operation.

Copy

Copies the folder.

Paste

Pastes a folder or script. This is only available if the folder or script has been copied.

Remove

Deletes the folder. If any scripts in the folder are 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

Rename the folder.

Properties

Displays the properties window.

Properties

Property Description

Name

The name of the folder.