VIEW: SYS.DBA_APPLY_CHANGE_HANDLERS

Source

View Text - Preformatted

select c.change_table_owner, c.change_table_name, c.source_table_owner,
         c.source_table_name, c.handler_name,
         decode(c.capture_values, 1, 'OLD',
                                  2, 'NEW',
                                  3, '*'),
         c.apply_name,
         decode(c.operation_name, 0, 'DEFAULT',
                                  1, 'INSERT',
                                  2, 'UPDATE',
                                  3, 'DELETE',
                                  4, 'LOB_UPDATE'),
         c.creation_time, c.modification_time
  from "_DBA_APPLY_CHANGE_HANDLERS" c, dba_apply a
  where a.apply_name = c.apply_name

View Text - HTML Formatted

SELECT C.CHANGE_TABLE_OWNER
, C.CHANGE_TABLE_NAME
, C.SOURCE_TABLE_OWNER
, C.SOURCE_TABLE_NAME
, C.HANDLER_NAME
, DECODE(C.CAPTURE_VALUES
, 1
, 'OLD'
, 2
, 'NEW'
, 3
, '*')
, C.APPLY_NAME
, DECODE(C.OPERATION_NAME
, 0
, 'DEFAULT'
, 1
, 'INSERT'
, 2
, 'UPDATE'
, 3
, 'DELETE'
, 4
, 'LOB_UPDATE')
, C.CREATION_TIME
, C.MODIFICATION_TIME
FROM "_DBA_APPLY_CHANGE_HANDLERS" C
, DBA_APPLY A
WHERE A.APPLY_NAME = C.APPLY_NAME