Bulk bind 대량 데이터 처리

--// 일반 FOR 루프 사용 FOR v_i IN p_km_arr.FIRST..p_km_arr.LAST LOOP update tst_lec_apply_mgr set gaesul_inwon = to_number(p_gaesul_inwon_arr(v_i)), use_yn = upper(p_use_yn_arr(v_i)), ks_cd = to_number(p_kscd_arr(v_i)) where yy = p_yy and hk = p_hk and km = p_km_arr(v_i) and kun = to_number(p_kun_arr(v_i)); END LOOP; --// FORALL 문으로 대량(Bulk) DML 처리방법(Bulk bind) /* 문법: FORALL index_row IN [ lower_bound ... upper_bound | INDICES OF indexing_collection | VALUES OF indexing_collection ] [ SAVE EXCEPTIONS ] sql_statement; */ FORALL v_i IN p_km_arr.FIRST..p_km_arr.LAST update skky_inwon set gaesul_inwon = to_number(p_gaesul_inwon_arr(v_i)), use_yn = upper(p_use_yn_arr(v_i)), ks_cd = to_number(p_kscd_arr(v_i)) where yy = p_yy and hk = p_hk and km = p_km_arr(v_i) and kun = to_number(p_kun_arr(v_i));