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, 1606🔥, 0💬
Popular Posts:
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Locate and Take Substrings with CHARINDEX() and SUBSTRING() Functions in SQL Server Transact-...