create global temporary table temp_TEST(IMP_TEST_DTL_NO number) ON COMMIT DELETE ROWS ;
insert into temp_TEST values (1);
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;
