DBA Data[Home] [Help]

VIEW: SYS.ALL_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",c."CAPTURE_VALUES",c."APPLY_NAME",c."OPERATION_NAME",c."CREATION_TIME",c."MODIFICATION_TIME"
  from DBA_APPLY_CHANGE_HANDLERS c, all_apply a
  where c.apply_name = a.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"
, C."CAPTURE_VALUES"
, C."APPLY_NAME"
, C."OPERATION_NAME"
, C."CREATION_TIME"
, C."MODIFICATION_TIME"
FROM DBA_APPLY_CHANGE_HANDLERS C
, ALL_APPLY A
WHERE C.APPLY_NAME = A.APPLY_NAME