VIEW: SYS.SM$INTEGRITY_CONS

Source

View Text - Preformatted

select owner || '.' || table_name table_name, constraint_name,
    decode(status, 'ENABLED', 'Y', NULL) enabled from sys.dba_constraints

View Text - HTML Formatted

SELECT OWNER || '.' || TABLE_NAME TABLE_NAME
, CONSTRAINT_NAME
, DECODE(STATUS
, 'ENABLED'
, 'Y'
, NULL) ENABLED
FROM SYS.DBA_CONSTRAINTS