臨時テーブルの作成

--臨時テーブル
CREATE GLOBAL TEMPORARY TABLE TEMP_TEST
( ID NUMBER,
  IMAGE_DATA BLOB
) ON COMMIT DELETE ROWS ;

INSERT INTO TEMP_TEST VALUES (1, EMPTY_BLOB());
SELECT 0 FROM MST_TEST TEST
INNER JOIN TEMP_TEST  TMP
ON TEST.IMP_TEST_DTL_NO = TMP.IMP_TEST_DTL_NO
FOR UPDATE NOWAIT;

UPDATE MST_TEST SET
TAISHO_DATA_MNT_FLG = 1
WHERE IMP_TEST_DTL_NO IN (SELECT * FROM TEMP_TEST);
DROP TABLE TEMP_TEST;