1
select * from DBA_CONSTRAINTS where owner = 'USER_GOES_HERE' and constraint_name = 'CONSTRAINT_NAME_GOES_HERE'
You can clone a snippet to your computer for local editing. Learn more.