Performing Operations on Multiple Database Objects at Once

You can select multiple database objects and collection nodes at once by holding down the shift or control key, and then selecting them. After selecting the nodes, you can right-click to display a menu of operations that can be performed on every selected node.

Only operations supported by all the selected nodes appear in the menu.

Operations that can be Performed on Multiple Selected Objects

For the Server Explorer nodes in which they appear, the following menu options can be performed on multiple selected objects. The descriptions indicate how multiple selection works with this option and supplements the menu option descriptions included with the specific Server Explorer nodes.

Menu Option	Description
Refresh	Refreshes selected nodes.
Properties	Displays in the property grid those properties that are common.
Copy	Copies all selected nodes, but only performs paste operation on types that are supported in the specific drop target.
Delete	Deletes each of the selected nodes in the order in which they were selected, in a batch mode.
Compile	Performs the following actions: If the procedure, function, trigger, or object is open in the PL/SQL Editor and has been changed, saves the changes to the database. Compiles the procedure, function, trigger, or object.
Compile Debug	Compiles the procedure, function, trigger, or object with debug information. This is required before PL/SQL code can be debugged. See Compiling a PL/SQL Program with Debug Information.
Generate Create Script	Writes the Server Explorer script definitions to a `.sql` file.
Generate Create Script to Project	Generates the Server Explorer script definitions to a .`sql` file and adds the `.sql` file to an open Oracle Database Project. If multiple objects in Server Explorer are selected, a master SQL script is created in the Oracle Database Project Scripts folder. This master script contains calls to individual child SQL scripts (one for each schema object) generated into the various schema object folders and this master script is ordered with dependencies taken into consideration. If there are multiple open Oracle Database projects, Visual Studio prompts you to select the project to add the script to. This operation can also be performed by dragging and dropping the Server Explorer node(s) directly onto a database project folder. See Managing Oracle Script Files for more information. Note: Oracle Database Project Version 2 projects are not supported. To add scripts to this project type, use Import Schema or Add Existing Item menu items on an Oracle Database Project Version 2 project folder, or use the Schema Compare tool.