오라클 NULL값 정렬 (NULLS FIRST, NULLS LAST)

WITH T AS (
SELECT  '경역기획' AS DEPT_NAME, '200' AS MANAGER_ID FROM DUAL
UNION 
SELECT  '경영'    AS DEPT_NAME, '201' AS MANAGER_ID FROM DUAL
UNION
SELECT  'IT'     AS DEPT_NAME, NULL AS MANAGER_ID FROM DUAL
UNION
SELECT  '물류'    AS DEPT_NAME, NULL AS MANAGER_ID FROM DUAL
UNION
SELECT  '회계'    AS DEPT_NAME, '204' AS MANAGER_ID FROM DUAL
)

SELECT  * FROM T
ORDER BY MANAGER_ID NULLS FIRST;


WITH T AS (
SELECT  '경역기획' AS DEPT_NAME, '200' AS MANAGER_ID FROM DUAL
UNION 
SELECT  '경영'    AS DEPT_NAME, '201' AS MANAGER_ID FROM DUAL
UNION
SELECT  'IT'     AS DEPT_NAME, NULL AS MANAGER_ID FROM DUAL
UNION
SELECT  '물류'    AS DEPT_NAME, NULL AS MANAGER_ID FROM DUAL
UNION
SELECT  '회계'    AS DEPT_NAME, '204' AS MANAGER_ID FROM DUAL
)

SELECT  * FROM T
ORDER BY MANAGER_ID NULLS LAST;