declare i number:=1; begin while i<=10 loop insert into ttt values(i); i:=i+1; end loop; commit; end; SQL> select * from ttt;
A ---------- 1 2 3 4 5 6 7 8 9 10
10 rows selected
什么意思呢.这个是产生10条记录 select rownum from dual connect by rownum <= 10;
--建表 create table a3(c number) --程序块 declare sl number; begin sl:=0; while sl<10 loop begin insert into A3 VALUES(1); commit; sl:=sl+1; end; end loop; end;
试试这个。 DECLARE i NUMBER := 1; BEGIN WHILE i <= 10 LOOP INSERT INTO tbl_testbak VALUES (i,1,2); i := i + 1; END LOOP; COMMIT; END;
你的TT表有几个字段,如果有>1个字段,那是会报错啊
SQL> declare 2 i number :=1; 3 begin 4 while i<=10 loop 5 insert into tb1 values(i); 6 i:=i+1; 7 end loop; 8 commit; 9 end; 10 /
i number:=1;
begin
while i<=10 loop
insert into ttt values(i);
i:=i+1;
end loop;
commit;
end;
SQL> select * from ttt;
A
----------
1
2
3
4
5
6
7
8
9
10
10 rows selected
select rownum from dual connect by rownum <= 10;
--建表
create table a3(c number)
--程序块
declare
sl number;
begin
sl:=0;
while sl<10 loop
begin
insert into A3 VALUES(1);
commit;
sl:=sl+1;
end;
end loop;
end;
试试这个。
DECLARE
i NUMBER := 1;
BEGIN
WHILE i <= 10 LOOP
INSERT INTO tbl_testbak VALUES (i,1,2);
i := i + 1;
END LOOP;
COMMIT;
END;
SQL> declare
2 i number :=1;
3 begin
4 while i<=10 loop
5 insert into tb1 values(i);
6 i:=i+1;
7 end loop;
8 commit;
9 end;
10 /
PL/SQL procedure successfully completed
SQL> select * from tb1;
C1
-----
1
2
3
4
5
6
7
8
9
10
10 rows selected