oracle pivot

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;