ALL_TYPE_ATTRS
describes the attributes of the object types accessible to the current user.
Related Views
DBA_TYPE_ATTRS
describes the attributes of all object types in the database. This view does not include the CHAR_USED
column.
USER_TYPE_ATTRS
describes the attributes of the object types owned by the current user. This view does not display the OWNER
or CHAR_USED
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
Owner of the type |
|
|
|
Name of the type |
|
|
|
Name of the attribute |
|
|
|
Type modifier of the attribute:
|
|
|
|
Owner of the type of the attribute |
|
|
|
Name of the type of the attribute |
|
|
|
Length of the |
|
|
|
Decimal precision of the |
|
|
|
Scale of the |
|
|
|
Character set name of the attribute ( |
|
|
|
Syntactical order number or position of the attribute as specified in the type specification or |
|
|
|
Indicates whether the attribute is inherited from a supertype ( |
|
|
|
Indicates whether the attribute uses |
See Also: