뷰 목록보기
SELECT VIEW_NAME, TEXT FROM USER_VIEWS;
JOIN으로 VIEW 생성하기 (존재하면 변경하여 생성한다)
CREATE OR REPLACE VIEW VIEW_EMP_DEPT
AS
SELECT E.EMPNO, E.ENAME, E.SAL, E.DEPTNO, D.DNAME, D.LOC
FROM EMP E, DEPT D
WHERE E.DEPTNO=D.DEPTNO
ORDER BY EMPNO DESC;
뷰를 생성할 권한 부여하기 (DBA)
GRANT CREATE VIEW TO SCOTT;
뷰삭제
DROP VIEW 뷰이름;
