效果图
sql语句如下:
with X as
(select level as lv from dual connect by level <=9),
Y as
(select a.lv as lv_a,
b.lv as lv_b,
to_char(b.lv) || ' x ' || to_char(a.lv) || ' = ' || rpad(to_char(a.lv * b.lv),2,' ') as text
from X a,X b
where b.lv <= a.lv)
select listagg(Y.text,' ') within group (order by Y.lv_b) as 九九乘法表
from Y
group by Y.lv_a;
sql语句如下:
with X as
(select level as lv from dual connect by level <=9),
Y as
(select a.lv as lv_a,
b.lv as lv_b,
to_char(b.lv) || ' x ' || to_char(a.lv) || ' = ' || rpad(to_char(a.lv * b.lv),2,' ') as text
from X a,X b
where b.lv <= a.lv)
select listagg(Y.text,' ') within group (order by Y.lv_b) as 九九乘法表
from Y
group by Y.lv_a;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/31098809/viewspace-2126119/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/31098809/viewspace-2126119/