Home > SQL Developer Dialog Boxes ... > Create Type (User-Defined)
This dialog box is displayed when you right-click Types in the Connections navigator and select Create Type to create a user-defined type. After you complete the information in this dialog box and click OK, a SQL Worksheet is displayed in which you must specify the appropriate definition of the type.
Schema: Database schema in which to create the type.
Name: Name of the type. Must be unique within its schema.
Type: Select the type of data type to be created: array type, object type specification, object type specification and type body, or table type.
For more information about creating a user-defined type, see the CREATE TYPE statement in Oracle Database SQL Language Reference.
For information about Oracle-supplied types, see Data Types: Usage Information.
Related Topics