代码:
select ltrim(sys_connect_by_path
(rownum || '*' || lv || '=' || rpad(rownum * lv, 2),' ')
)
from (select level lv from dual connect by level < 10)
where lv = 1
connect by lv + 1 = prior lv;
LTRIM(SYS_CONNECT_BY_PATH(ROWN
--------------------------------------------------------------------------------
1*1=1
2*2=4 2*1=2
3*3=9 3*2=6 3*1=3
4*4=16 4*3=12 4*2=8 4*1=4
5*5=25 5*4=20 5*3=15 5*2=10 5*1=5
6*6=36 6*5=30 6*4=24 6*3=18 6*2=12 6*1=6
7*7=49 7*6=42 7*5=35 7*4=28 7*3=21 7*2=14 7*1=7
8*8=64 8*7=56 8*6=48 8*5=40 8*4=32 8*3=24 8*2=16 8*1=8
9*9=81 9*8=72 9*7=63 9*6=54 9*5=45 9*4=36 9*3=27 9*2=18 9*1=9
9 rows selected
......