[Home] [Help] [Dependency Information]
Object Name: | ALL_TYPES |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Description of types accessible to the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
OWNER | VARCHAR2 | (128) | Owner of the type | |
TYPE_NAME | VARCHAR2 | (128) | Name of the type | |
TYPE_OID | RAW | (16) | Object identifier (OID) of the type | |
TYPECODE | VARCHAR2 | (128) | 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 | (128) | Owner of the supertype (null if type is not a subtype) | |
SUPERTYPE_NAME | VARCHAR2 | (128) | 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 |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, TYPE_NAME
, TYPE_OID
, TYPECODE
, ATTRIBUTES
, METHODS
, PREDEFINED
, INCOMPLETE
, FINAL
, INSTANTIABLE
, SUPERTYPE_OWNER
, SUPERTYPE_NAME
, LOCAL_ATTRIBUTES
, LOCAL_METHODS
, TYPEID
FROM SYS.ALL_TYPES;
|
|
|