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;