<< Click to Display Table of Contents >>

Create Type

Top Previous Next

This modal dialog lets you create a PL/SQL type. It shows the following information:

Name of the type

Choose one of the following radio group items

Varying Array. Use the spin edit control to enter the array size.

Table

Object

Base data type. The ellipsis (..) button opens a second dialog to specify the PL/SQL data type.

Data type dialog

You can select a data type by clicking on the corresponding tab sheet:

User defined type. Please enter the following information:

Ref check box. If checked, the object represents a reference to the object type, not the type itself.

Owner of the type. Can be selected from a combo box.

Name of the type. Can be selected from a combo box.

Character types. You can select the type name from a radio group. Don't forget to enter the type length.

Numeric types. You can select the type name from a radio group. Don't forget to enter the precision and data scale.

Other types. You can select the type name from a radio group.

After the OK button is pressed, the data type definition is completed, and the type is created. The cancel button closes the dialog without any action.