select * from table_name
as of timestamp to_timestamp('200709171130','yyyymmddhh24mi');

select * from table_name
as of timestamp to_timestamp('200709171130','yyyymmddhh24mi')
where ..... ;

select * from table_name
as of timestamp to_timestamp('200709171130','yyyymmddhh24mi');

現在不是太清楚的是閃回查詢9i下是查詢undo裡面的東西，是否還查詢這個table現在的資料，因為返回的不是更新的資料，而是整個table .

Oracle9i,.10g 閃回查詢(flashback)

相關文章