能不能根据时间点,检索到更新前某个时间点的数据状态?我在FAQ上看到一篇有关闪回的用法,其中有这样的一句SQL:
SELECT * FROM table AS OF TIMESTAMP (to_timestamp('20051108 08:00:33','yyyymmdd hh24:mi:ss'));问的弱了一点,还望高手指点
SELECT * FROM table AS OF TIMESTAMP (to_timestamp('20051108 08:00:33','yyyymmdd hh24:mi:ss'));问的弱了一点,还望高手指点
IS
CURSOR curTypeInfo IS SELECT * FROM t_TypeInfo ;
Rec curtypeinfo%ROWTYPE;
BEGIN
dbms_flashback.enable_at_time(SYSDATE-120/1440);
OPEN curTypeInfo ;
dbms_flashback.disable;
LOOP
FETCH curTypeInfo INTO Rec;
EXIT WHEN curTypeInfo%NOTFOUND;
INSERT INTO t_TypeInfo( f_Typecategory,f_Typeid, f_Typecode,f_Typename,f_Description,f_Typeorder ,f_Rowflag)
VALUES(rec.f_Typecategory,rec.f_Typeid,rec.f_Typecode,rec.f_Typename,rec.f_Description,rec.f_Typeorder ,rec.f_Rowflag);
END LOOP;
end up_FlashBack;//首先赋权对dbms_flashback 有执行的权限!
用这个存储过程能找回来!