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
oranje
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.

Report message to a moderator

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
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Search the Forum for "auditing" and "database triggers".

Report message to a moderator

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
amul
Messages: 252
Registered: April 2001
Location: Chennai
Senior Member
no one s going to lock this one?maaher?

Report message to a moderator

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: 9100
Registered: November 2002
Location: California, USA
Senior Member
Just because you asked. In the traditional Maaher style.

http://www.orafaq.com/forum/fa/448/0/

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Dec 12 05:05:14 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.