Home » SQL & PL/SQL » SQL & PL/SQL » Database Trigger (oracle)
Database Trigger [message #447789] Wed, 17 March 2010 21:07 Go to next message
art_ora
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: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
v$session.program
v$session.machine
sys_context('userenv','host')

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


Current Time: Sat Feb 15 08:41:55 CST 2025