Collections:
Create a New View in Oracle
How To Create a New View in Oracle?
✍: FYIcenter.com
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
2020-02-07, 3460🔥, 0💬
Popular Posts:
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
How Run SQL*Plus Commands That Are Stored in a Local File in Oracle? If you have a group of commands...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
What Is Oracle in Oracle? Oracle is a company. Oracle is also a database server, which manages data ...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...