ALL_TYPE_ATTRS describes the attributes of the object types accessible to the current user.
DBA_TYPE_ATTRS describes the attributes of all object types in the database.
USER_TYPE_ATTRS describes the attributes of the object types owned by the current user. This view does not display the OWNER column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
OWNER |
VARCHAR2(30) |
Owner of the type | |
TYPE_NAME |
VARCHAR2(30) |
Name of the type | |
ATTR_NAME |
VARCHAR2(30) |
Name of the attribute | |
ATTR_TYPE_MOD |
VARCHAR2(7) |
Type modifier of the attribute:
|
|
ATTR_TYPE_OWNER |
VARCHAR2(30) |
Owner of the type of the attribute | |
ATTR_TYPE_NAME |
VARCHAR2(30) |
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 (CHAR_CS or NCHAR_CS) |
|
ATTR_NO |
NUMBER |
Syntactical order number or position of the attribute as specified in the type specification or CREATE TYPE statement (not to be used as an ID number) |
|
INHERITED |
VARCHAR2(3) |
Indicates whether the attribute is inherited from a supertype (YES) or not (NO) |
|
CHAR_USED |
VARCHAR2(1) |
Indicates whether the attribute uses BYTE length semantics (B) or CHAR length semantics (C). For NCHAR and NVARCHAR2 attribute types, this value is always C. |
See Also: