UC知道帮忙用Oracle代码编写九九乘法表
来源：百度知道 编辑：UC知道 时间：2024/05/12 15:38:43
分别用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;
oracle中的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;
oracle中的PL/SQL代码...怎么不能编写代码??
正确答案：
select reverse(sys_connect_by_path(reverse(rpad(rownum * lv, 2)) || '=' ||
rownum || '*' || lv,
' '))
from (select level lv from dual connect by level < 10)
where lv = 1
connect by lv + 1 = prior lv;
oracle可以运行脚本程序就没必要在plus里编写代码了