[ORACLE] CONNECT BY LEVEL - ORDER BY 절

SELECT a.*

FROM

(SELECT LEVEL SEQN

FROM DUAL

CONNECT BY LEVEL < 20 ) a

ORDER BY SEQN || ' '

 

-- 1, 10,11,12 .... 19, 2 ,3 ,4...9 로 나옴 

 

 

SELECT a.*

FROM

(SELECT LEVEL SEQN

FROM DUAL

CONNECT BY LEVEL < 20 ) a

ORDER BY SEQN || ' '+0

 

-- 1, 2, 3 ...10, 11 ... 20으로 나옴