Home » SQL & PL/SQL » SQL & PL/SQL » SQL help needed
SQL help needed [message #186348] Mon, 07 August 2006 10:37 Go to next message
Messages: 2
Registered: August 2006
Location: 299 Park Ave, Manhattan, ...
Junior Member
My table project has 20 columns. One of the column called 'operation' has 'U' for Update and 'I' for Insert showing that something has been updated or inserted in that particular row. I have to compare the rows and show both what the old value was and the new value that was updated is. So my table should look something like this:

updateddate updatedby old-value new-value

with date prompt for user to enter.

Any help with be greatly appreciated.
Re: SQL help needed [message #186377 is a reply to message #186348] Mon, 07 August 2006 14:10 Go to previous messageGo to next message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Search the Forum for "auditing" and "database triggers".
Re: SQL help needed [message #186539 is a reply to message #186377] Tue, 08 August 2006 07:13 Go to previous messageGo to next message
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
no one s going to lock this one?maaher?
Re: SQL help needed [message #186848 is a reply to message #186539] Wed, 09 August 2006 18:22 Go to previous message
Barbara Boehmer
Messages: 8606
Registered: November 2002
Location: California, USA
Senior Member
Just because you asked. In the traditional Maaher style.


Previous Topic: exluding records based on date
Next Topic: Is there any limit for stored procedure's arguments?
Goto Forum:

Current Time: Thu Oct 20 16:41:14 CDT 2016

Total time taken to generate the page: 0.08074 seconds