Oracle object type

If we are just creating type without specifying clause as shown below then by default it will create type with which datatype i.e. varchar or number

CREATE TYPE <TYP_NAM开发者_C百科E>

This is an Incomplete Type.

An incomplete type would be used where a type references a second type that references the first type (a circular reference such as emp-supervisor). This allows the incomplete type to be referenced before it is completed. However, before a table can be constructed from an incomplete type, it must be completed.