Static Data Dictionary Views, 117 of 521

ALL_TYPES

ALL_TYPES describes all object types accessible to the user.

USER_TYPES describes all object types owned by the current user. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`		Owner of the type
`TYPE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the type
`TYPE_OID`	`RAW(16)`	`NOT NULL`	Object identifier (OID) of the type
`TYPECODE`	`VARCHAR2(30)`		Typecode of the type
`ATTRIBUTES`	`NUMBER`		Number of attributes in the type
`METHODS`	`NUMBER`		Number of methods in the type
`PREDEFINED`	`VARCHAR2(3)`		Indicates whether the type is a predefined type
`INCOMPLETE`	`VARCHAR2(3)`		Indicates whether the type is an incomplete type
`FINAL`	`VARCHAR2(3)`		(`YES`/`NO`) Indicates whether the type is final
`INSTANTIABLE`	`VARCHAR2(3)`		(`YES`/`NO`) Indicates whether the type is instantiable
`SUPERTYPE_OWNER`	`VARCHAR2(30)`		Name of the supertype owner. `NULL` if type is not a subtype.
`SUPERTYPE_NAME`	`VARCHAR2(30)`		Name of the supertype. `NULL` if type is not a subtype.
`LOCAL_ATTRIBUTES`	`NUMBER`		Number of local attributes (not inherited). `NULL` if not a subtype.
`LOCAL_METHODS`	`NUMBER`		Number of local methods (not inherited). `NULL` if not a subtype.
`TYPEID`	`RAW(16)`		Type ID value of the type