Views

Views in Oracle SQL

A view is a virtual table based on a query. It does not store data but simplifies access and security.

CREATE VIEW emp_dept_view AS
SELECT e.employee_id, e.first_name, d.department_name
FROM employees e JOIN departments d ON e.department_id = d.department_id;