all_cons_columns « System Tables Data Dictionary « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Tables Data Dictionary
  3. all_cons_columns
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