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.
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: 2834
Registered: May 2007
Location: Scotland
Senior Member
Read the documentation on Flashback Queries, or you could look at logminer
Previous Topic: problem with table trigger?
Next Topic: Selecting one of the Union Clause
Goto Forum:
  


Current Time: Fri Dec 02 12:12:51 CST 2016

Total time taken to generate the page: 0.15648 seconds