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.
精彩评论