I have update Row in table using spoofi.how Revert that update Row it means original position?

Interview Candidate
Jun 6th, 2005
3
2228

First
Prev
Next
Last

Showing Answers 1 - 3 of 3 Answers

B L Praveen

Sep 21st, 2007

You keep track of changes you have done to the row later on update back to your orginal data.

Col1
------
0

Update tbl1
set col1 = 1
where key1 = 111

Col1
-----
1

Update tbl1
set col1 = 0
where key1 = 111

Col1

If you have update many rows then you need to load the table again.
-----
0