Home » SQL & PL/SQL » SQL & PL/SQL » Database level DML triggers
Database level DML triggers [message #251310] Thu, 12 July 2007 19:14 Go to next message
Messages: 1
Registered: July 2007
Junior Member

I need to track the changes made to any table in the database in terms of data, not in the terms of structure. How do I do that with a single trigger? Is it possible to write a database level DML triggers? or shall I need to create triggers for each table in the database to track changes and record the changes to LOG.

Thanks in advance!!!

Re: Database level DML triggers [message #251319 is a reply to message #251310] Thu, 12 July 2007 21:29 Go to previous message
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Take a look at auditing.

Ross Leishman
Previous Topic: ERROR - ORA-28000: the account is locked
Next Topic: can a CASE is included in Where Clause.....
Goto Forum:

Current Time: Wed Oct 26 22:19:28 CDT 2016

Total time taken to generate the page: 0.11586 seconds