query oracle constraint by name

select * from all_constraints where owner = ‘DAT_TEST’ and constraint_name = ‘SYS_C0025628’

Advertisements