BEGIN
for i in 1..10000 loop
insert into BN_USER(USER_ID,USER_PHONE,USER_SEX,REGISTER_TIME,WECHAT) values(BN_USER_REQUENCE.NEXTVAL,i,0,sysdate,'oHOlkwWViA6GuFRkcd0tPFTxmPM4'||i);
end loop;
end;
oracle 循环insert
最新推荐文章于 2024-08-15 17:22:33 发布