2008年6月10日 星期二

Generate 9x9 using Oracle10g SQL Statement


SELECT X,Y,X*Y
FROM
(SELECT level x FROM DUAL CONNECT BY LEVEL <= 9),
(SELECT level y FROM DUAL CONNECT BY LEVEL <= 9)