[Oracle] ORDER BY DECODE / CASE 특정 값 우선정렬하기

DECODE

SELECT *
	FROM [테이블명]
    ORDER BY DECODE( [컬럼명], '첫번째값', 1),
    		 DECODE( [컬럼명], '두번째값', 2);

CASE

SELECT *
	FROM [테이블명]
    ORDER BY (CASE WHEN [컬럼명] = '첫번째값' THEN 1 END),
    		 (CASE WHEN [컬럼명] = '두번째값' THEN 2 END);