Get information on all the column constraints you have access to using all_cons_columns. : all_cons_columns « System Tables Data Dictionary « Oracle PL/SQL Tutorial






SQL>
SQL> desc all_cons_columns;
 Name              Null?    Type
 ------------------

 OWNER             NOT NULL VARCHAR2(30)
 CONSTRAINT_NAME   NOT NULL VARCHAR2(30)
 TABLE_NAME        NOT NULL VARCHAR2(30)
 COLUMN_NAME                VARCHAR2(4000)
 POSITION                   NUMBER

SQL>
SQL> --select * from all_cons_columns;
SQL>








30.4.all_cons_columns
30.4.1.Get information on all the column constraints you have access to using all_cons_columns.
30.4.2.Join user_constraints and user_cons_columns to get the column_name, constraint_name, constraint_type, and status