SELECT X,Y,X*Y
FROM
(SELECT level x FROM DUAL CONNECT BY LEVEL <= 9),
(SELECT level y FROM DUAL CONNECT BY LEVEL <= 9)
2008年6月10日 星期二
Generate 9x9 using Oracle10g SQL Statement
訂閱:
文章 (Atom)
This blog is dedicated to my love - Henrry Huang
SELECT X,Y,X*Y
FROM
(SELECT level x FROM DUAL CONNECT BY LEVEL <= 9),
(SELECT level y FROM DUAL CONNECT BY LEVEL <= 9)