VIEW: SYS.DBA_APPLY_DML_CONF_HANDLERS

Source

View Text - Preformatted

select
  apply_name, schema_name, object_name, old_schema, old_object,
  decode(opnum, 1, 'INSERT',
                2, 'UPDATE',
                3, 'DELETE'),
  decode(conflict_type, 1, 'ROW_EXISTS',
                        2, 'ROW_MISSING'),
  decode(method_num, 1, 'IGNORE',
                     2, 'RECORD',
                     3, 'DELTA',
                     4, 'OVERWRITE',
                     5, 'MAXIMUM',
                     6, 'MINIMUM'),
  conflict_handler_name, resolution_column,
  decode(set_by,  NULL,'USER',
                     1,'GOLDENGATE')
from sys."_DBA_APPLY_DML_CONF_HANDLERS"

View Text - HTML Formatted

SELECT APPLY_NAME
, SCHEMA_NAME
, OBJECT_NAME
, OLD_SCHEMA
, OLD_OBJECT
, DECODE(OPNUM
, 1
, 'INSERT'
, 2
, 'UPDATE'
, 3
, 'DELETE')
, DECODE(CONFLICT_TYPE
, 1
, 'ROW_EXISTS'
, 2
, 'ROW_MISSING')
, DECODE(METHOD_NUM
, 1
, 'IGNORE'
, 2
, 'RECORD'
, 3
, 'DELTA'
, 4
, 'OVERWRITE'
, 5
, 'MAXIMUM'
, 6
, 'MINIMUM')
, CONFLICT_HANDLER_NAME
, RESOLUTION_COLUMN
, DECODE(SET_BY
, NULL
, 'USER'
, 1
, 'GOLDENGATE') FROM SYS."_DBA_APPLY_DML_CONF_HANDLERS"