Oracle用PL/SQL打印菱形和乘法口诀表

-- 菱形
declare
begin
  for i in 1..5 loop  -- i=1 i=2
    for j in 1..5-i loop -- j=1-4 j=3
      dbms_output.put(' ');
      end loop;
      for j in 1..i*2-1 loop -- j=1 j=1-3
        dbms_output.put('*');
        end loop;
      dbms_output.put_line('');
  end loop;
  for i in reverse 1..5 loop
    for j in 1..5-i loop
      dbms_output.put(' ');
      end loop;
      for j in 1..i*2-1 loop
        dbms_output.put('*');
        end loop;
      dbms_output.put_line('');
  end loop;
end;

--打印乘法表
declare
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;