뷰

CREATE [OR REPLACE] VIEW 뷰이름 (컬럼1, 컬럼2, 컬럼3, ... ) AS ( SELECT 문 );

DROP VIEW 뷰이름;

CREATE OR REPLACE VIEW VE_EMP_DEPT AS SELECT e.emp_id ,e.emp_name ,d.dept_id ,d.dept_title ,e.email ,e.phone -- 주민등록번호 ,RPAD( SUBSTR(emp_no, 1, 8), 14, '*' ) emp_no -- 입사일자 ,TO_CHAR( hire_date, 'YYYY.MM.DD' ) hire_date -- 급여 ,TO_CHAR( salary, '999,999,999' ) salary -- 연봉 ,TO_CHAR( (salary + NVL( salary*bonus, 0)) * 12, '999,999,999,999') yr_salary FROM employee e LEFT JOIN department d ON (e.dept_code = d.dept_id) ;

SELECT * FROM VE_EMP_DEPT;