ORACLE 구구단 출력 SQL

ORACLE 구구단 출력 SQL

WITH N AS (
    SELECT LEVEL AS N 
      FROM DUAL 
CONNECT BY LEVEL<10) 
SELECT A.N||'X'||B.N||'='||A.N*B.N AS DATA 
  FROM N A, N B
 ;
 
 --Query Output
 DATA
1X1=1
1X2=2
1X3=3
1X4=4
1X5=5
1X6=6
1X7=7
1X8=8
1X9=9
2X1=2
2X2=4
2X3=6
2X4=8
...