Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Procedure or function to create insert scripts on table

3574779Oct 7 2018 — edited Oct 7 2018

Hi,

I have a requirment to monitor dml statements on few tablesĀ  and gather the scripts.we have dba audit table but we are not getting required data some times

Can we write a procedure to genrate insert script on tables passed as parameter.

Later can we use that procedure in dml trigger to generate the script values and store in a table as clob value.please give ur suggestions

Comments
Post Details
Added on Oct 7 2018
1 comment
192 views