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, 1608🔥, 0💬
Popular Posts:
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...