How to catching "data change events"

[cy163]

Hello, everybody

I am wondering how to catch the events of data changing(inserting,updating) of oracle db in a java program.


Because,I need to do some kind of processing in a java program whenever inserting or updating a record in oracle .

[Ned Pepper]

You can find that a DML statement was executed on a table by querying ALL_TAB_MODIFICATIONS. That table will give you a count of inserts, updates and deletes. You could try turning on user session logging, or you can find the DML statements by examining the redo log files. Oracle provides a means to accomplish this through logminer. Check out https://docs.oracle.com/cd/B19306_01...5/logminer.htm. All of this would be after the dml is/are committed.