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

VIEW: SYS.ALL_TYPE_ATTRS

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

Description of attributes of types accessible to the user

[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 ?
CHAR_USED VARCHAR2 (1)
C if the width was specified in characters, B if in bytes
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
,      CHAR_USED
FROM SYS.ALL_TYPE_ATTRS;

Dependencies

[top of page]

SYS.ALL_TYPE_ATTRS references the following:

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

SchemaPUBLIC
SynonymALL_TYPE_ATTRS