Was this helpful?
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