Oracle : 셀렉트 문에서 순번을 매겨 조회하기

SELECT
ROW_NUMBER() OVER(ORDER BY c_sort ASC) AS rnum,
c_code, c_name, c_showchk, c_sort, rownum
FROM tableName