database/oracle
실수로 삭제한 쿼리 복구
두억시니
2014. 7. 15. 14:00
1 2 3 4 5 6 7 | INSERT INTO S_UPDATELOG SELECT * FROM (SELECT * FROM S_UPDATELOG AS OF TIMESTAMP (SYSTIMESTAMP - INTERVAL '60' MINUTE) A WHERE A.STNO = '2009432007' AND A.CHANGECODE = '21' AND A.CHANGEYEAR = '2012'; | cs |