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	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`)