Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

ALL_TYPE_ATTRS

ALL_TYPE_ATTRS describes the attributes of the object types accessible to the current user.

Related Views

Column Datatype NULL Description
OWNER VARCHAR2(128)   Owner of the type
TYPE_NAME VARCHAR2(128)   Name of the type
ATTR_NAME VARCHAR2(128)   Name of the attribute
ATTR_TYPE_MOD VARCHAR2(7)   Type modifier of the attribute:
  • REF

  • POINTER

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 (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.