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, 1346👍, 0💬
Popular Posts:
How To Format Time Zone in +/-hh:mm Format in SQL Server Transact-SQL? From the previous tutorial, y...
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
How to download and install SQL Server 2005 Sample Scripts in SQL Server? If you want to learn from ...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...