Online Documentation for SQL Manager for Oracle

Creating/editing array type


Use the Array Type tab of Array Type Editor to create/edit an array type and specify its properties.

 

Name

Specify the name of the new array type or nested table type, or view the name of the array type / nested table type being edited. Note that the type name must be unique within its schema.

 

Schema

Use the drop-down list to specify the schema in which the array type or nested table type will be created.

 

Array Type Editor - Editing Array Type definition

 

RadioButton Varray

Specifies the varray type (a type composed of an ordered set of elements, each of which has the same datatype).

 

Array size

Use the spinner control to specify a maximum limit for the array.

 

RadioButton Nested table

Specifies the nested table type.

 

Data type

Type

Use the drop-down list to select a built-in datatype, REF or <nested_object>.

If data type is an object type, then the nested table type describes a table whose columns match the name and attributes of the object type. If defined data type is a scalar type, then the nested table type describes a table with a single, scalar type column called COLUMN_VALUE.

 

Object schema

Use the drop-down list to select the schema containing the REF or object type.

 

Object

Use the drop-down list to select the REF or object type.

 

Size / Scale

Use the spinner controls to specify the size and/or scale (for numeric data types).

 

To compile the object, use the corresponding iconCompile Compile item of the Navigation bar or toolbar.