DATABASE
[ORACLE] CONNECT BY LEVEL - ORDER BY 절
오래오래 늘 함께
2019. 9. 24. 13:12
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으로 나옴