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

VIEW: SYS.DBA_TYPE_ATTRS

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

Description of attributes of all types in the database

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (128) Yes Owner of the type
TYPE_NAME VARCHAR2 (128) Yes Name of the type
ATTR_NAME VARCHAR2 (128) Yes Name of the attribute
ATTR_TYPE_MOD VARCHAR2 (7)
Type modifier of the attribute
ATTR_TYPE_OWNER VARCHAR2 (128)
Owner of the type of the attribute
ATTR_TYPE_NAME VARCHAR2 (128)
Name of the type of the attribute
LENGTH NUMBER

Length of the CHAR attribute or maximum length of the VARCHAR or VARCHAR2 attribute
PRECISION NUMBER

Decimal precision of the NUMBER or DECIMAL attribute or binary precision of the FLOAT attribute
SCALE NUMBER

Scale of the NUMBER or DECIMAL attribute
CHARACTER_SET_NAME VARCHAR2 (44)
Character set name of the attribute
ATTR_NO NUMBER
Yes Syntactical order number or position of the attribute as specified in the type specification or CREATE TYPE statement (not to be used as ID number)
INHERITED VARCHAR2 (3)
Is the attribute inherited from the supertype ?
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      TYPE_NAME
,      ATTR_NAME
,      ATTR_TYPE_MOD
,      ATTR_TYPE_OWNER
,      ATTR_TYPE_NAME
,      LENGTH
,      PRECISION
,      SCALE
,      CHARACTER_SET_NAME
,      ATTR_NO
,      INHERITED
FROM SYS.DBA_TYPE_ATTRS;

Dependencies

[top of page]

SYS.DBA_TYPE_ATTRS references the following:

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

SchemaAPPS
Package BodyETRM_PNAV - show dependent code
SchemaMDSYS
Package BodySDO_WFS_PROCESS - show dependent code
SchemaPUBLIC
SynonymDBA_TYPE_ATTRS
SchemaSYS
ProcedurePATCH_XDB$RESOURCE_T - show dependent code