[Oracle] Merge, 실수로 Delete했을때, Update Join

1. Merge
MERGE INTO MBASWCMST_BAK A USING MBASWCMST  B ON(A.WC_CD = B.WC_CD)
WHEN MATCHED THEN UPDATE SET A.OP_RATE = B.OP_RATE;

2. 실수로 Delete 했을때
SELECT * FROM MWIPWORKLOT
 AS OF TIMESTAMP ( SYSTIMESTAMP - INTERVAL '10' MINUTE)
WHERE  ENG_NO = 'AAAAA';

3. Update Join
DECLARE CURSOR CSR1 IS
   SELECT LOT_NO      AS LOT_NO     ,
          BAD_LOT_SER AS BAD_LOT_SER
   FROM   MQCMBADLOT;
BEGIN
   FOR REC1 IN CSR1 LOOP
      UPDATE MQCMBADMST
      SET    BAD_LOT_SER = REC1.BAD_LOT_SER
      WHERE  LOT_NO      = REC1.LOT_NO;
   END LOOP;
END;