例子
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;
标签:存储,end,DATE,number,start,num,oracle,run,过程 From: https://www.cnblogs.com/alamZ/p/17650259.html