Question: how cdc works in oracle?
Answer: A synchronous Oracle change data capture is implemented using triggers that inserts entries to a change-table every time a data modification operation is executed. Triggers are hooks that get executed as part of the transactions.