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, 1565🔥, 0💬
Popular Posts:
What Happens If the UPDATE Subquery Returns Multiple Rows in SQL Server? If a subquery is used in a ...
How To Find Out What Privileges a User Currently Has in Oracle? Privileges granted to users are list...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
How To Convert Characters to Numbers in Oracle? You can convert characters to numbers by using the T...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...