../E40402-16.epub /> ../E40402-16.mobi />

ALL_OBJ_COLATTRS

ALL_OBJ_COLATTRS describes object columns and attributes contained in the tables accessible to the current user.

Related Views

  • DBA_OBJ_COLATTRS describes object columns and attributes contained in all tables in the database.

  • USER_OBJ_COLATTRS describes object columns and attributes contained in the tables owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description
OWNER VARCHAR2(30)   Owner of the table
TABLE_NAME VARCHAR2(30)   Name of the table containing the object column or attribute
COLUMN_NAME VARCHAR2(4000)   Fully qualified name of the object column or attribute
SUBSTITUTABLE VARCHAR2(15)   Indicates whether the column is substitutable (Y) or not (N)