[Oracle] CONNECT BY LEVEL Example

 

Oracle CONNECT BY LEVEL 사용방법

 

 

CONNECT BY LEVEL - 계층형쿼리, LEVEL사용하여 For문처럼 사용하기

SELECT LEVEL FROM DUAL CONNECT BY LEVEL <= N

ex) SELECT LEVEL FROM DUAL CONNECT BY LEVEL <= 7