DBA Data[Home] [Help]

VIEW: SYS.DBA_REPAUDIT_COLUMN

Source

View Text - Preformatted

select
    sname,
    oname,
    column_name,
    base_sname,
    base_oname,
    decode(base_conflict_type_id,
           1, 'UPDATE',
           2, 'UNIQUENESS',
           3, 'DELETE',
           'UNDEFINED'),
    base_reference_name,
    attribute
from  system.repcat$_audit_column
View Text - HTML Formatted

SELECT SNAME
, ONAME
, COLUMN_NAME
, BASE_SNAME
, BASE_ONAME
, DECODE(BASE_CONFLICT_TYPE_ID
, 1
, 'UPDATE'
, 2
, 'UNIQUENESS'
, 3
, 'DELETE'
, 'UNDEFINED')
, BASE_REFERENCE_NAME
, ATTRIBUTE FROM SYSTEM.REPCAT$_AUDIT_COLUMN