DBA_TYPES
Description of all types in the database
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| OWNER | VARCHAR2 | (30) | Owner of the type | |
| TYPE_NAME | VARCHAR2 | (30) | Yes | Name of the type |
| TYPE_OID | RAW | (16) | Yes | 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) | Is the type a predefined type? | |
| INCOMPLETE | VARCHAR2 | (3) | Is the type an incomplete type? | |
| FINAL | VARCHAR2 | (3) | Is the type a final type? | |
| INSTANTIABLE | VARCHAR2 | (3) | Is the type an instantiable type? | |
| SUPERTYPE_OWNER | VARCHAR2 | (30) | Owner of the supertype (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 (not inherited) attributes (if any) in the subtype | ||
| LOCAL_METHODS | NUMBER | Number of local (not inherited) methods (if any) in the subtype | ||
| TYPEID | RAW | (16) | Type id value of the type |
Usage:
cursor cur_type(c_name in dba_types.type_name%type
, c_owner in dba_types.owner%type) is
SELECT TYPECODE
, ATTRIBUTES
, METHODS
, PREDEFINED
, INCOMPLETE
FROM SYS.DBA_TYPES
where owner = c_owner
and type_name = c_name;