VIEW: SYS.INT$DBA_CONSTRAINTS

Source

View Text - Preformatted

select OWNER, CONSTRAINT_NAME, CONSTRAINT_TYPE,
       TABLE_NAME, OBJECT_ID, OBJECT_TYPE#, SEARCH_CONDITION,
       SEARCH_CONDITION_VC, R_OWNER, R_CONSTRAINT_NAME, DELETE_RULE, STATUS,
       DEFERRABLE, DEFERRED, VALIDATED, GENERATED,
       BAD, RELY, LAST_CHANGE, INDEX_OWNER, INDEX_NAME,
       INVALID, VIEW_RELATED, SHARING, ORIGIN_CON_ID
from   INT$INT$DBA_CONSTRAINTS INT$INT$DBA_CONSTRAINTS
where  INT$INT$DBA_CONSTRAINTS.OBJECT_TYPE# = 4         /* views */
       OR (INT$INT$DBA_CONSTRAINTS.OBJECT_TYPE# = 2     /* tables */
           AND (INT$INT$DBA_CONSTRAINTS.ORIGIN_CON_ID
                = TO_NUMBER(SYS_CONTEXT('USERENV', 'CON_ID'))))

View Text - HTML Formatted

SELECT OWNER
, CONSTRAINT_NAME
, CONSTRAINT_TYPE
, TABLE_NAME
, OBJECT_ID
, OBJECT_TYPE#
, SEARCH_CONDITION
, SEARCH_CONDITION_VC
, R_OWNER
, R_CONSTRAINT_NAME
, DELETE_RULE
, STATUS
, DEFERRABLE
, DEFERRED
, VALIDATED
, GENERATED
, BAD
, RELY
, LAST_CHANGE
, INDEX_OWNER
, INDEX_NAME
, INVALID
, VIEW_RELATED
, SHARING
, ORIGIN_CON_ID FROM INT$INT$DBA_CONSTRAINTS INT$INT$DBA_CONSTRAINTS WHERE INT$INT$DBA_CONSTRAINTS.OBJECT_TYPE# = 4 /* VIEWS */ OR (INT$INT$DBA_CONSTRAINTS.OBJECT_TYPE# = 2 /* TABLES */
AND (INT$INT$DBA_CONSTRAINTS.ORIGIN_CON_ID = TO_NUMBER(SYS_CONTEXT('USERENV'
, 'CON_ID'))))