oracle创建大量模拟数据

SQL> create table t1 (id number(10),name varchar(20));

Table created.

SQL> begin
for i in 1 .. 1000000
loop
insert into t1 values(i,'yy');
end loop;
commit;
end;
/

  

posted @ 2022-07-29 10:32  orcl  阅读(156)  评论(0编辑  收藏  举报