oracle 存储过程
例子
declare v_start number:= 42113+1*1000+1; run_num number:= 1000; v_end number:= v_start+run_num-1; BEGIN for i in v_start..v_end loop INSERT INTO IKAS_ALAM_TEST(PPID, COLUMN1, COLUMN2, CREATE_DATE, UPDATE_DATE) VALUES(i, '', '', '', SYSDATE); end loop;commit; end;