Query to find all constraints in a table

col type format a10
col cons_name format a30
select decode(constraint_type,
‘C’, ‘Check’,
‘O’, ‘R/O View’,
‘P’, ‘Primary’,
‘R’, ‘Foreign’,
‘U’, ‘Unique’,
‘V’, ‘Check view’) type
, constraint_name cons_name
, status
, last_change
from dba_constraints
where owner like ‘&owner’
and table_name like ‘&table_name’
order by 1
/
  • January 21, 2019 | 19 views
  • Comments