VARRAY Type Nodes
This section covers the following topics:
About VARRAY Type Nodes
A VARRAY Type node is a child of the User-Defined Types node. It represents a VARRAY type defined in the database.
How VARRAY Type Nodes Work
A VARRAY type node has a different icon than an object type node or nested table type node.A VARRAY type node will have a child node only if the VARRAY type has an element of user-defined type in the database.
For more information, see Oracle Database Object-Relational Developer's Guide.
To perform actions on this 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 node's menu.
Menu Options
| Menu Option | Description |
|---|---|
|
Edit |
Opens the type definition for the VARRAY Type in a PL/SQL Editor Window. |
|
Query Window |
Opens the Query Window so that you can execute SQL and PL/SQL queries from Visual Studio. |
|
Generate Custom Class |
Launches the Oracle Custom Class Wizard for the selected VARRAY type. See Using the Oracle Custom Class Wizard. |
|
Generate Create Script… |
Writes the VARRY type definition to a |
|
Generate Create Script to Project |
Generates the VARRAY type definition to a Generates the VARRAY type node definition to a . 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. |
|
Delete |
Drops the VARRAY type from the database. |
|
Refresh |
Updates the VARRAY Type node. |
|
Properties |
Displays the Properties window. |