declare
i integer; --定义变量
begin
i := 1;
loop
/* 插入数据 */
INSERT INTO
HME_pkn_container(KID,CODE,CONTAINER_TYPE_ID,ENABLE_FLAG,
FREE_FLAG,SERVER_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,
LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)
VALUES
(hme_pkn_container_s.nextval,'4197000030000' + i,'42','Y',
'Y','41970000001','10001',sysdate,'10001',sysdate,'14996');
/* 参数递增 */
i := i + 1;
/* 停止条件 */
exit when i > 10000;
end loop;
commit; |