pivot主要用于交叉报表
with l as
(select level as lv from dual connect by level <= 9),
m as
(select a.lv as lv_a,
b.lv as lv_b,
to_char(b.lv) || ' × ' || to_char(a.lv) || ' = ' ||
rpad(to_char(a.lv * b.lv), 2, ' ') as text
from l a, l b
where b.lv <= a.lv)
select "1", "2", "3", "4", "5", "6", "7", "8", "9"
from m
pivot (max(m.text) for lv_b in(1, 2, 3, 4, 5, 6, 7, 8, 9))
order by 1;