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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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
189 views