--ROWID: ROW이 실제 저당된 테이블의 고유주소
--ROWNUM: ROW의 주소 순서대로 출력
SELECT ROWID, ROWNUM, EMPNO
FROM EMP;
CREATE OR REPLACE VIEW RANK_VIEW
AS
SELECT RANK, ENAME, SAL
FROM (SELECT ROWNUM RANK, ENAME, SAL
FROM (SELECT ENAME, SAL FROM EMP
ORDER BY SAL DESC))
WHERE RANK BETWEEN 6 AND 10;
SELECT * FROM RANK_VIEW;