DB/오라클
[오라클] COMMIT 복구
데르벨준
2014. 12. 29. 18:23
반응형
<기본 쿼리>
SELECT A.STATUS_CD
FROM SIEBEL.S_SRC AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '15' MINUTE) A
;
-- 15는 15분을 의미함
<응용>
UPDATE SIEBEL.S_SRC SRC
SET STATUS_CD = (
SELECT STATUS_CD
FROM SIEBEL.S_SRC
AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '15' MINUTE) A
WHERE SRC.ROW_ID = A.ROW_ID
)
WHERE EXISTS (
SELECT 'X'
FROM SIEBEL.S_SRC
AS OF TIMESTAMP(SYSTIMESTAMP - INTERVAL '15' MINUTE) A
WHERE SRC.ROW_ID = A.ROW_ID
)
;
COMMIT;
반응형