Hi Admin, I got that solution for DDL but whats about DML statement? And my question is for some specific days. So please let me know this. If any script could have made would be helpful. Regards Pablo n


Default Asked on September 2, 2018 in ORACLE.
Add Comment
1 Answer(s)

One way is –


  1. Create a new table like .

create table DML_MONIT ( action_date , insert,update,delete) .


2. Create a triggers with condition, that when any insert,update,delete happens on ur original table, the new table DML_MONIT will be updated accordingly.

like, for each insert, DML_MONIT table column ACTION_DATE will be updated with sysdate and insert will be flagged as 1.



However trigger may impact the performance of the DML operation on the original table, If transactions are very high.






Newbie Answered on September 5, 2018.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.