使用While插入大批量数据(PL/SQL)

最新推荐文章于 2022-09-14 20:17:00 发布

Pomona

最新推荐文章于 2022-09-14 20:17:00 发布

阅读量1.1k

点赞数

文章标签： integer insert sql

本文链接：https://blog.csdn.net/Pomona/article/details/2662227

版权

在SQL window执行下列命令可循环插入大批量数据。

Declare
counter Binary_Integer :=1;
datasquce Integer:=10000;

Begin
While counter <= 10000 Loop
insert into BORT0020 values(datasquce,'1','7890','0140','7','20080714','20080715','00000001','1','1000000000','03','03','1','00011','000001','000003','03','1000','500.00','10','10000','5000','0','0','20070707','1','1','1','2','3','4','5','6','7','8','9','10','0','20070714','164500','20080715','205325','BBS00101','1','1','0');
datasquce:=datasquce+1;
counter := counter+1;
End Loop;
End;