Oracle Database Interview Question:

How To Create a New View in Oracle?

Submitted by: Administrator

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;
<pre>FIRST_NAME LAST_NAME DEPARTMENT_NAME
-------------------- ------------------- ----------------
Nancy Greenberg Finance
Jennifer Whalen Administration
Susan Mavris Human Resources
Hermann Baer Public Relations
Shelley Higgins Accounting</pre>
Submitted by: Administrator