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, 1462🔥, 0💬
Popular Posts:
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To List All Login Names on the Server in SQL Server? If you want to see a list of all login name...
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
How To Drop an Index in Oracle? If you don't need an existing index any more, you should delete it w...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...