Collections:
Use of SELECT Statements in Views in Oracle
Can SELECT Statements Be Used on Views in Oracle?
✍: FYIcenter.com
Select (query) statements can used on views in the same way as tables. The following tutorial exercise helps you creating a view and running a query statement on the view:
SQL> CREATE VIEW managed_dept AS SELECT * FROM departments WHERE manager_id IS NOT NULL; View created. SQL> SELECT * FROM managed_dept WHERE location_id = 1700; DEPARTMENT_ID DEPARTMENT_NAME MANAGER_ID LOCATION_ID ------------- -------------------- ---------- ----------- 10 Administration 200 1700 30 Purchasing 114 1700 90 Executive 100 1700 100 Finance 108 1700 110 Accounting 205 1700
⇒ Filter Out Duplications in Returning Rows in Oracle
⇐ Count the Number of Rows with SELECT Statements in Oracle
2019-12-19, 1474🔥, 0💬
Popular Posts:
How To Break Query Output into Pages in MySQL? If you have a query that returns hundreds of rows, an...
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Get the Definition of a User Defined Function Back in SQL Server Transact-SQL? If you want ge...
How To Create a Stored Program Unit in Oracle? If you want to create a stored program unit, you can ...
How To Update Multiple Rows with One UPDATE Statement in SQL Server? If the WHERE clause in an UPDAT...