ALL_CONS_OBJ_COLUMNS

List of types an object column or attribute is constrained to in the tables accessible to the user

Columns
   ___________________________
 
   OWNER
      Owner of the table
   TABLE_NAME
      Name of the table containing the object column or attribute
   COLUMN_NAME
      Fully qualified name of the object column or attribute
   CONS_TYPE_OWNER
      Owner of the type that the column is constrained to
   CONS_TYPE_NAME
      Name of the type that the column is constrained to
   CONS_TYPE_ONLY
      Indication of whether the column is constrained to ONLY type