ORACLE : SHOW CONSTRAINT

select *
from user_constraints
where constraint_name = :const_name;