create table e ( a numeric, b varchar2(50) ); 方法1: declare temp varchar2(20):='aaaa'; i number; begin for i in 1..100 loop insert into e(a,b) values(i,temp); end loop; end;
方法2:
update t set order_id = rownum where rownum <= 200;
create table e ( a numeric, b varchar2(50) ); 方法1: declare temp varchar2(20):='aaaa'; i number; begin for i in 1..100 loop insert into e(a,b) values(i,temp); end loop; end;
方法2:
update t set order_id = rownum where rownum <= 200;