DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.DBA_TYPES

Object Details
Object Name: DBA_TYPES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

Description of all types in the database

[View Source]

Columns
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
Query Text

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.DBA_TYPES;

Dependencies

[top of page]

SYS.DBA_TYPES references the following:

SchemaSYS
TableTYPE$
TableUSER$
View_CURRENT_EDITION_OBJ
SYS.DBA_TYPES is referenced by following:

SchemaAPPS
Package BodyETRM_PNAV - show dependent code
SchemaPUBLIC
SynonymDBA_TYPES
SchemaSYS
Package BodyDBMSOBJG - show dependent code
Package BodyDBMS_DBFS_SFS_ADMIN - show dependent code
Package BodyDBMS_DEFER_QUERY_UTL - show dependent code
Package BodyDBMS_REPCAT_MAS - show dependent code
Package BodyDBMS_REPCAT_UTL - show dependent code
Package BodyXDB_MIGRATESCHEMA - show dependent code