第四章 pl/sql 乘法口诀表的使用

乘法口诀表
— for 循环：
declare
i positive;
j positive;
begin
for i in 1..9 loop –外层循环变量
for j in 1..i loop
dbms_output.put(
i
|| ‘*’
|| j
|| ‘=’
||i * j
|| ’ ‘);
end loop;
dbms_output.put_line(”);
end loop;

end;

declare
num number;
begin
for j in 1..9 loop
for i in 1..j loop
num:=i*j;
if i

end;

declare
i number:=1;
j number:=1;
num number;
begin
while j<=9 loop
while i<=j loop
num:=i*j;
if i

end;

declare
i number:=1;
j number:=1;
num number;
begin
loop
loop
num:=i*j;
if i

end;

declare
i number:=1;
j number:=1;
begin
loop
j:=1;
loop
dbms_output.put(i||’*’||j||’=’||rpad(i*j,2,’ ‘)||’ ‘);
j:=j+1;
exit when j>=i;
end loop;
dbms_output.put_line(’ ‘);
i:=i+1;
exit when i>9;
end loop;
end;