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, 1700🔥, 0💬
Popular Posts:
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
What is SQL Server Transact-SQL (T-SQL)? SQL Server Transact-SQL, also called T-SQL, is an extension...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How To Generate CREATE VIEW Script on an Existing View in SQL Server? If you want to know how an exi...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...