Home » SQL & PL/SQL » SQL & PL/SQL » If any Provision to Know the Updated records data. (Windows XP)
If any Provision to Know the Updated records data. [message #315605] Tue, 22 April 2008 02:49 Go to next message
cvs_1984
Messages: 136
Registered: August 2007
Location: Punjab, INDIA
Senior Member
Hai,

I want to known how to, If i made any modification in a row of table and then i forget the modification made, If any provision to known the previous data of the row.

Example:

Select Emplcode,Empladdr from emplmast where emplcode = 1;

Emplcode empladdr
-------- --------------------------------------
1 No: 12 Chennai TN.

Update Emplmast set empladdr = 'NO: 15, Chennai TN.' where emplcode =1;

1 row updated.


commit;


After commit i want to see the previous address. How to known it.

Report message to a moderator

Re: If any Provision to Know the Updated records data. [message #315607 is a reply to message #315605] Tue, 22 April 2008 02:51 Go to previous message
pablolee
Messages: 2882
Registered: May 2007
Location: Scotland
Senior Member
Read the documentation on Flashback Queries, or you could look at logminer

Report message to a moderator

Previous Topic: problem with table trigger?
Next Topic: Selecting one of the Union Clause
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Jul 08 19:20:12 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.