SQL Constraints List

Find SQL constraint:

SELECT *
FROM all_constraints
where CONSTRAINT_NAME LIKE 'ConstraintName'