SHARE
TWEET

Untitled

a guest Oct 3rd, 2019 93 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT
  2.    all_cons_columns.owner AS schema_name,
  3.    all_cons_columns.table_name,
  4.    all_cons_columns.column_name,
  5.    ALL_CONS_COLUMNS.POSITION,
  6.    ALL_CONS_COLUMNS.CONSTRAINT_NAME,
  7.    all_constraints.status
  8. FROM all_constraints, all_cons_columns
  9. WHERE
  10.    all_constraints.constraint_type = 'P'
  11.    AND all_constraints.constraint_name = all_cons_columns.constraint_name
  12.    AND all_constraints.owner = all_cons_columns.owner
  13. ORDER BY
  14.    all_cons_columns.owner,
  15.    ALL_CONS_COLUMNS.TABLE_NAME,
  16.    all_cons_columns.position;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top