Use of SELECT Statements in Views in Oracle

Q

Can SELECT Statements Be Used on Views in Oracle?

✍: FYIcenter.com

A

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

Understanding SQL SELECT Query Statements in Oracle

⇑⇑ Oracle Database Tutorials

2019-12-19, 1459🔥, 0💬