select * from /test/batch /** output() **/ ; BEGIN BATCH update /test/batch set v_float = 1.2 where v_varchar='4006' ; update /test/batch set v_float = 1.2 where v_varchar='40' ; update /test/batch set v_float = 1.2 where v_varchar='400'; update /test/batch set v_float = 1.2 where v_varchar='74006'; update /test/batch set v_float = 1.2 where v_varchar='409'; update /test/batch set v_float = 1.2 where v_varchar='500'; update /test/batch set v_float = 1.2 where v_varchar='600'; update /test/batch set v_float = 1.2 where v_varchar='700'; update /test/batch set v_float = 1.2 where v_varchar='602'; update /test/batch set v_float = 1.2 where v_varchar='708'; END ;