oracle for loop塞資料
DECLARE
V_BGN_INT NUMBER := 1021;
V_END_INT NUMBER := 10000;
BEGIN
FOR L_TEST IN V_BGN_INT .. V_END_INT LOOP
INSERT INTO yimt004 (yimt004_id,catalog_name,catalog_id,doc_user_id)
VALUES (L_TEST,L_TEST,L_TEST,'07082');
END LOOP;
COMMIT;
END;
