Create a New View in Oracle

Q

How To Create a New View in Oracle?

✍: FYIcenter.com

A

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

 

Drop an Existing View in Oracle

Drop an Existing Index in Oracle

Understanding SQL DDL Statements for Oracle

⇑⇑ Oracle Database Tutorials

2020-02-07, 1346👍, 0💬