Home » SQL & PL/SQL » SQL & PL/SQL » storing log of sql statements (oracle 9i sql)
storing log of sql statements [message #279191] Wed, 07 November 2007 05:05 Go to next message
athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member
hi everyone, in want to store the log of sql statements performed in a table like

if a user insert,update or delete some data
that should be recorded in a table as

username, action, date, tablename

any help will be greatly
appreciated.

[Updated on: Wed, 07 November 2007 05:06]

Report message to a moderator

Re: storing log of sql statements [message #279193 is a reply to message #279191] Wed, 07 November 2007 05:08 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Database Application Developer's Guide - Fundamentals
Chapter 9 Coding Triggers
Section Examples of Trigger Applications

Regards
Michel
Previous Topic: concate value in single row
Next Topic: Can view be called inside a view.
Goto Forum:
  


Current Time: Thu Dec 08 22:31:31 CST 2016

Total time taken to generate the page: 0.08131 seconds