Forum Stats

  • 3,814,894 Users
  • 2,258,926 Discussions
  • 7,892,883 Comments

Discussions

Procedure or function to create insert scripts on table

3574779
3574779 Member Posts: 16
edited Oct 7, 2018 10:02AM in SQL & PL/SQL

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

Tagged:

Answers

  • John Thorton
    John Thorton Member Posts: 14,493 Silver Crown
    edited Oct 7, 2018 10:02AM
    3574779 wrote: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

    What required data is  missing?

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

    I give up.

    Can you?

    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

    Your specific requirements are unclear

    Please read the content of URL below & respond accordingly.

    How do I ask a question on the forums?

    Why are NONE of your threads marked as ANSWERED?

    3574779