Database관련/Oracle

oracle Delete 후 commit 잘못해서 데이터 날려 먹었을때 sql

천상의날개 2013. 3. 21. 13:52

INSERT INTO 테이블  
 
SELECT *
 
FROM 테이블 
AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '60' MINUTE);

commit;