Nested Table Type Designer

The Nested TableType Designer creates new nested table types.

This section covers the following topics:

• Creating Nested Tables in Oracle Developer Tools

• Starting the Nested Table Designer

• Using the Nested Table Designer

Creating Nested Tables in Oracle Developer Tools

Use the Nested Table Designer to create Nested Table types.

Starting the Nested Table Designer

Start the Nested Table Designer from the Server Explorer by right-clicking the User-Defined Categories node, and selecting the New Nested Table. The Nested Table Type Designer, similar to the following appears.

Description of the illustration nestedtable_designer.gif

Using the Nested Table Designer

The Nested Table Designer creates new nested table types.

The controls in the Nested Table Designer are as follows:

Control	Description
Schema name	Select the schema for the new type. The list contains all the schemas that are available to you as defined in the Filters Tab on the Connection Dialog. By default, the schema for the new Nested Table type is the one you have logged in with. If that schema was not defined in the apply filter dialog box, then the default schema is the first schema in the sorted list of available schemas.
Type name	Displays the name of the new Nested Table type. By default, the name is generated in the form NESTEDTABLEXXX where X can be any number.
Element Properties	This section enables you to specify properties for the element of the Nested Table type. The first property, Type, is constant. Other properties change based on the type. Type: The data type of the element of the Nested Table type. The list contains all the database predefined types, ANSI types, and available user-defined types. When the type changes, other attribute properties change. You cannot create attributes of these data types: LONG, LONG RAW, ROWID, and UROWID. Size: Represents the size of Character types. Default is 20. Precision: For types DECIMAL, NUMBER, NUMERIC: Represents precision for numeric types. You can specify the precision for the type in this field. The default value is empty, meaning no precision is specified. For types TIMESTAMP, TIMESTAMP_WITH_TIME_ZONE, TIMESTAMP_WITH_LOCAL_TIME_ZONE, and FLOAT: Represents the fraction seconds precision for the timestamp type. Default is 6. Scale: For types DECIMAL, NUMBER, NUMERIC: Represents the scale for numeric types. Default value is empty, meaning no scale is specified. Day: For INTERVAL_DAY_TO_SECOND: Represents the day precision for the interval type. Default is 2. Fractional second: For INTERVAL_DAY_TO_SECOND: Represents the seconds precision for the interval type. Default value is 6. Year Precision: For INTERVAL_YEAR_TO_MONTH: Represents the precision in terms of year, Default value is 2.
Preview SQL	Launches the preview SQL Dialog box which displays the CREATE statement that creates the Nested Table type in the database.
Cancel	Closes the dialog box without creating the Nested Table type in database.
Help	Launches the help page for New Nested Table dialog.
Ok	Adds the newly created Nested Table type to the User-Defined Types in Server Explorer and opens the Nested Table type definition in the PL/SQL editor.