效果图
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博客 ” ，链接：https://blog.itpub.net/31098809/viewspace-2126119/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
用shell自动创建用户
请登录后发表评论
登录
全部评论
