Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Join user_constraints and user_cons_columns table

SQL> SQL> SELECT dc.table_name, dcc.column_name, dcc.position,   2         dcc.constraint_name, dc.constraint_type, dc.search_condition   3  FROM   user_constraints dc, user_cons_columns dcc   4  WHERE  dcc.table_name      = dc.table_name   5  AND    dcc.owner           = dc.owner   6  AND    dcc.constraint_name = dc.constraint_name   7  and    rownum < 50   8  ORDER BY dcc.table_name, dcc.owner, dcc.position, dcc.column_name; no rows selected