CREATE VIEW Example
Define a view of employee data including names, salaries, and name of manager.
create view empdpt (ename, sal, dname)
as select employee.name, employee.salary, dept.name
from employee, dept
where employee.mgr = dept.mgr;
Last modified date: 01/30/2023