用SQL实现9*9乘法表

With Nums As
 (Select Level Num From Dual Connect By Level < 10)
Select Max(Decode(a, 1, Exp)) a, Max(Decode(a, 2, Exp)) b, Max(Decode(a, 3, Exp)) c, Max(Decode(a, 4, Exp)) d, Max(Decode(a, 5, Exp)) e,
       Max(Decode(a, 6, Exp)) f, Max(Decode(a, 7, Exp)) g, Max(Decode(a, 8, Exp)) h, Max(Decode(a, 9, Exp)) i
From (Select a.Num a, b.Num b, a.Num || '*' || b.Num || '=' || Lpad(a.Num * b.Num, 2, ' ') Exp From Nums a, Nums b Where a.Num <= b.Num)
Group By b

Order By a;

效果: