select table名稱.* from table名稱as of timestamp (SYSTIMESTAMP-interval '刪除時間' Minute)
語法範例
select table.* from table as of timestamp (SYSTIMESTAMP-interval '60' Minute)
資料來源:http://arjudba.blogspot.com/2008/04/how-to-restore-old-data-using-flashback.html