How To Create a New View?

You can create a new view based on one or more existing tables by using the CREATE VIEW
statement as shown in the following script:
CREATE VIEW employee_department AS
SELECT e.employee_id, e.first_name, e.last_name, e.email,
e.manager_id, d.department_name
FROM employees e, departments d
WHERE e.department_id = d.department_id;
View created.
SELECT first_name, last_name, department_name
FROM employee_department WHERE manager_id = 101;
FIRST_NAME LAST_NAME DEPARTMENT_NAME
-------------------- ------------------------- ------------------
Nancy Greenberg Finance
Jennifer Whalen Administration
Susan Mavris Human Resources
Hermann Baer Public Relations
Shelley Higgins Accounting