PL/SQL语言循环简单语句练习

1.打印九九乘法表

1）利用for循环

declare
begin
for v_i in 1..9 loop
for v_j in 1..v_i loop
dbms_output.put(v_i||'*'||v_j||'='||v_i*v_j||' ');
end loop;
dbms_output.put_line('');
end loop;
end;

2）利用while循环

declare
v_i int:=1;
v_j int:=1;
begin

while v_i<10 loop
v_j:=1;
while v_j<=v_i loop

dbms_output.put(v_j||'*'||v_i||'='||v_i*v_j||' ');
v_j:=v_j+1;
end loop;
dbms_output.put_line('');
v_i:=v_i+1;
end loop;
end;

（2）循环设置排序为ID号

declare
v_id tbl_regions.regions_id%type;
begin
for  v_i in 1..35 loop
select t.regions_id into v_id from  tbl_regions t where t.regions_id=v_i;
dbms_output.put_line(v_id);
update tbl_regions s set s.regions_sort = v_id  where s.regions_id=v_i;
end loop;
end;