A script-enabled browser is required for this page to function properly.

Type Wizard Overview

The Type Wizard leads you through the steps necessary to create a new Oracle user-defined datatype, which may be an object type or a collection type.

An object type is a template that specifies the elements or attributes of a structured data unit. Attributes may be Built-in datatypes or other structured data units. An object type also specifies the operations or methods you can perform on the data unit. Methods are functions or procedures written in PL/SQL and stored in the database, or they could be written in C and stored externally.

A collection type may be a table type or a varying array type. Each collection type describes a data unit that consists of an indefinite number of elements, all of the same datatype.

A table type or nested table is an unordered set of data elements. It has a single column, which may be a Built-in datatype or an object type. If an object type, the table can also be viewed as a multi-column table, with a column for each attribute of the object type.

A varying array type or VARRAY is an ordered set of data elements. The number of elements is variable and it refers to the size of the array. You must specify a maximum size when declaring the varying array type.

You can use the Type Wizard to create an object type (with attributes and methods), table type or VARRAY. Specifically, use the Type Wizard to complete the following tasks:

Navigating in the Type Wizard

The following buttons are provided to help you navigate your way through the pages:

Note: If you click Next or Back before you have entered all necessary information for a particular page, the wizard prevents you from navigating to the next (or previous) page. Similarly, if you have not entered all necessary information into the wizard when you click Finish, the wizard automatically places you onto the page where you can finish entering the required data.


About Oracle Database Server user-defined datatypes

Creating an Oracle Database Server user-defined datatype with the Type Wizard

Oracle Database Server Object Support in the Object Navigator

Editing an Oracle Database Server user-defined datatype

Deleting an Oracle Database Server user-defined datatype