How to retrieve constraints in oracle :

SELECT t.constraint_name, t.constraint_type, ct.column_name
FROM user_constraints t
INNER JOIN user_cons_columns ct on ct.constraint_name = t.constraint_name
WHERE t.table_name = '?' AND t.constraint_type = 'U' AND ct.column_name = '?';
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s