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
ramana_dodda
Messages: 1
Registered: July 2007
Junior Member
Hi,

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!!!

Regards,
Ramana.
Re: Database level DML triggers [message #251319 is a reply to message #251310] Thu, 12 July 2007 21:29 Go to previous message
rleishman
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: Mon Dec 05 03:13:11 CST 2016

Total time taken to generate the page: 0.28111 seconds