我修改数据的时候提交了怎么恢复呢??ORACLE9I表如
TABLE1
NAME SEX
KELE 男
KDL 女
... 男
... 男
... 女
UPDATE TABLE1 SET NAME='KELE' WHERE SEX='男';
commit;
怎么将原来的数据恢复
TABLE1
NAME SEX
KELE 男
KDL 女
... 男
... 男
... 女
UPDATE TABLE1 SET NAME='KELE' WHERE SEX='男';
commit;
怎么将原来的数据恢复
UPDATE TABLE1 A
SET NAME = (SELECT NAME
FROM TABLE1 B AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '1' HOUR)
WHERE SEX = '男'
AND A.ROWID = B.ROWID)
WHERE SEX = '男'
AND EXISTS (SELECT NULL
FROM TABLE1 B AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '1' HOUR)
WHERE SEX = '男'
AND A.ROWID = B.ROWID);