code_junkie

How do I find the definition of a system-named constraint in Oracle?

Nov 10th, 2011
107
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.19 KB | None | 0 0
  1. DBMS_METADATA.GET_DDL('CONSTRAINT', 'SYS_C003415')
  2.  
  3. select OWNER, CONSTRAINT_NAME, CONSTRAINT_TYPE, TABLE_NAME, SEARCH_CONDITION from ALL_CONSTRAINTS where CONSTRAINT_NAME = 'SYS_C003415';
Add Comment
Please, Sign In to add comment