SQL 循环插入10000条

最新推荐文章于 2023-12-26 12:05:05 发布

weixin_30832351

最新推荐文章于 2023-12-26 12:05:05 发布

阅读量469

点赞数

文章标签：数据库 python

原文链接：http://www.cnblogs.com/eternal1025/p/5177216.html

版权

SQL> create table tt_test ( x int, y char(50) );

Table created.

SQL>
SQL> begin
  2      for i in 1 .. 100000
  3      loop
  4          insert into t values ( i, 'x' );
  5      end loop;
  6      commit;
  7  end;
  8  /

PL/SQL procedure successfully completed.

SQL>
SQL> select count(*) from t;

  COUNT(*)
----------
    100000

SQL>
SQL> drop table t;

Table dropped.

SQL>

转载于:https://www.cnblogs.com/eternal1025/p/5177216.html