oracle优雅for 循环插入 in loop insert

来源:互联网 发布:网络安全策略的分类 编辑:程序博客网 时间:2024/05/17 01:08
create table computers( comNo number(4)  constraint PK_comp primary key, compModel varchar2(64) constraint unique_comp unique, buyTime date, price number(12,2) constraint ch_price check( price>0 and price<=300000), owner varchar2(32));DECLARE  i number := 0;BEGIN  for i in 1 .. 3000 loop    insert into computers      (comNo, compModel, buyTime, price, owner)    values      (i, '8' + i, to_date('' + sysdate, 'YYYY-MM'), i, 'zhangsan');    --dbms_output.put_line(i);  end loop;  commit;END;

0 0
原创粉丝点击