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

 

Understanding SQL SELECT Query Statements in Oracle

⇒⇒Oracle Database Tutorials

2016-10-17, 169👍, 0💬