Home » SQL & PL/SQL » SQL & PL/SQL » Database Trigger (oracle)
Database Trigger [message #447789] Wed, 17 March 2010 21:07 Go to next message
Messages: 10
Registered: May 2008
Junior Member
Hi everyone, I want to have an audit table for our audit trail, that for every edit or delete on the table it will save it to our audit table. When I put it on the database trigger, it is passible to get the name of the program or system and the column that are edit, because my table audit trail has an column for program name and column name? Is there any function?

Thanks, Art
Re: Database Trigger [message #447793 is a reply to message #447789] Wed, 17 March 2010 23:46 Go to previous message
Michel Cadot
Messages: 63911
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Previous Topic: Comparing two tables DATA
Next Topic: A flexible Constraint
Goto Forum:

Current Time: Sat Oct 22 11:11:19 CDT 2016

Total time taken to generate the page: 0.04840 seconds