帮忙用PL/SQL代码编写九九乘法表

Question

分别用For loop循环和While loop循环编写,运行环境PL/SQL!
下面是用basic loop写的,供各位参考!
declare
v_num1 number;
v_num2 number;
v_str varchar2(200);
begin
v_num1:=1;
v_num2:=1;
loop
loop
v_str:=v_str||to_char(v_num2)||'*'||to_char(v_num1)||'='||substr(to_char((v_num1*v_num2)||' '),1,2);
v_num2:=v_num2+1;
v_str:=v_str||' ';
exit when v_num2>v_num1;
end loop;
dbms_output.put_line(v_str);
v_num1:=v_num1+1;
v_str:='';
v_num2:=1;
exit when v_num1>9;
end loop;
end;

Answer 1

#include <stdio.h>

void main()

{
int i=1,j;
while (i<=9)
{
j=i;
while (j<=i)
{
printf("%d*%d=%d",i,j,i*j);
j++; //j=j+1
}
}
printf("\n");
i++; //i=i+1
}

Answer 2

select
max(case when a < 1 then '' else '1*'+cast(a as varchar)+'='+cast(a*1 as varchar) end) as [1],
max(case when a < 2 then '' else '2*'+cast(a as varchar)+'='+cast(a*2 as varchar) end) as [2],
max(case when a < 3 then '' else '3*'+cast(a as varchar)+'='+cast(a*3 as varchar) end) as [3],
max(case when a < 4 then '' else '4*'+cast(a as varchar)+'='+cast(a*4 as varchar) end) as [4],
max(case when a < 5 then '' else '5*'+cast(a as varchar)+'='+cast(a*5 as varchar) end) as [5],
max(case when a < 6 then '' else '6*'+cast(a as varchar)+'='+cast(a*6 as varchar) end) as [6],
max(case when a < 7 then '' else '7*'+cast(a as varchar)+'='+cast(a*7 as varchar) end) as [7],
max(case when a < 8 then '' else '8*'+cast(a as varchar)+'='+cast(a*8 as varchar) end) as [8],
max(case when a < 9 then '' else '9*'+cast(a as varchar)+'='+cast(a*9 as varchar) end) as [9]
from (
select 1 as a
union all
select 2
union all
select 3
union all
select 4
union all
select 5
union all
select 6
union all
select 7
union all
select 8
union all
select 9
) as t1
group by a