日期:2014-05-17 浏览次数:21132 次
declare tag_hight number;
hight integer;
tag_body number;
bodytype number;
begin
tag_hight:=1;
hight:=160;
while(tag_hight<4) loop
--exit when tag_hight>3;
tag_body:=1;
bodytype:=130;
while(tag_gbdy<4)
loop
--exit when tag_body>3;
insert into YU values(tag_hight,'XX','YYY',to_char(bodytype)||'/'||to_char(hight)||'b','0');
bodytype:=bodytype+2;
tag_body:=tag_body+1;
end loop
tag_hight:=tag_hight+1;
hight:=hight+5;
end loop;
end;
SQL> select * from t; ID IDNAME TYPE --- ------------ ---- SQL> SQL> declare 2 tag_hight number; 3 hight integer; 4 tag_body number; 5 bodytype number; 6 begin 7 tag_hight:=1; 8 hight:=160; 9 while(tag_hight<4) loop 10 tag_body:=1; 11 bodytype:=130; 12 while(tag_body<4) 13 loop 14 insert into t values(1,'a',1); 15 bodytype:=bodytype+2; 16 tag_body:=tag_body+1; 17 end loop; 18 tag_hight:=tag_hight+1; 19 hight:=hight+5; 20 end loop; 21 end; 22 / PL/SQL procedure successfully completed SQL> select * from t; ID IDNAME TYPE --- ------------ ---- 1 a 1 1 a 1 1 a 1 1 a 1 1 a 1 1 a 1 1 a 1 1 a 1 1 a 1 9 rows selected SQL>
------解决方案--------------------
end loop 也不加个';'号