System Tables Data Dictionary Oracle PLSQL Tutorial

  1. Home
  2. Oracle PLSQL Tutorial
  3. System Tables Data Dictionary
  4. Get information on all the column constraints you have access to using all_cons_columns
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>