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, 3142🔥, 0💬
Popular Posts:
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 Get Help Information from the Server in MySQL? While you are at the "mysql>" prompt, y...
What Are the Differences between DATE and TIMESTAMP in Oracle? The main differences between DATE and...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...