VIEW 생산

CREATE VIEW 뷰이름;
AS
SELECT 컬럼명
FROM 테이블명;

예시

-- 도스창 들어가서 SQLplus 접속후 사용자 권한 부여 해야함
CREATE VIEW VIEW_EMP1
AS
SELECT EMPID,NAME,DEPT,HIRE_DATE,SALARY
FROM EMP;
-- WHERE SALARY >= 150;

CREATE VIEW VIEW_EMP2
AS
SELECT EMPID,NAME,DEPT,JOB
FROM EMP;

CREATE VIEW VIEW_EMP3
AS
SELECT EMPID,NAME,BIRTHDAY,ADDRESS
FROM EMP;