Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Reporting Update, Delete and Insert Transactions in Certain Tables as SQL Scripts.

Posted on 2011-10-04
Medium Priority
Last Modified: 2012-05-12
Hi Experts,

I need a Log table in which update, delete and insert transactions in certain  tables
will be  written as SQL scripts.     So, the dml  SQl commands which applied  in these tables  will be reported.   How can I do that ?

Question by:orcun_turkec
  • 3
  • 2
LVL 78

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36909354
Have you looked at auditing and log miner?

If you want to write it yourself I thing you will need triggers.

Author Comment

ID: 36909439
I haven' t looked at auditing  or log-miner  Slightwv.
Could you send me   some links or  info about auditing  ?  

Author Comment

ID: 36909464
And If I try to make it with triggers, how will the SQLs that make the dml changes  be  formed ?
I think I must use this way because I don' t have the sys user of the database.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 78

Accepted Solution

slightwv (䄆 Netminder) earned 2000 total points
ID: 36909918
On mobile and cannot find the links.  The online docs have all the info if you search the docs.

With triggers you just build the DML with the 'when updating', 'when inserting' and when deleting' clauses with the :old and :new column values based on what you want to do.
LVL 23

Expert Comment

ID: 36909998

Author Closing Comment

ID: 36942082
Thank you

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Suggested Courses
Course of the Month11 days, 16 hours left to enroll

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question