declare
width integer;
area integer;
height integer :=2;
counter integer:=0;
begin
/*
loop
counter := counter +1;
area:=6;
width := area/height;
dbms_output.put_line(width);
exit when counter =5;
end loop;
*/
/*
while counter <6 loop
counter := counter+1;
area:=6;
width := area/height;
dbms_output.put_line(width);
end loop;
*/
for count in 0..6 loop
counter := counter+1;
area := 6;
width := area/height;
dbms_output.put_line(width);
end loop;
end;
几个存储过程的例子
最新推荐文章于 2021-03-10 09:47:20 发布