advanced code snippet search

Posted By

geekzspot on 12/04/12


Tagged


Versions (?)

Oracle Select a Check Constraint

 / Published in: SQL
 

You can SELECT a CHECK CONSTRAINT

Expand | Embed | Plain Text 
  1. SELECT search_condition 
  2. FROM user_constraints
  3. WHERE CONSTRAINT_NAME = UPPER('&constraint_name'); -- Data Dictionary names are UPPERCASE.

Report this snippet  

You need to login to post a comment.