Categories:
.NET (961)
C (387)
C++ (185)
CSS (84)
DBA (8)
General (31)
HTML (48)
Java (641)
JavaScript (220)
JSP (109)
JUnit (31)
MySQL (297)
Networking (10)
Oracle (562)
Perl (48)
Perl (9)
PHP (259)
PL/SQL (140)
RSS (51)
Software QA (28)
SQL Server (5)
Struts (20)
Unix (2)
Windows (3)
XHTML (199)
XML (59)
Other Resources:
Can SELECT Statements Be Used on Views
Can SELECT Statements Be Used on Views? - Oracle DBA FAQ - Understanding SQL SELECT Query Statements
✍: 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
2007-04-20, 4844👍, 0💬
Popular Posts:
What is the FP per day in your current company?
What is the difference between Class and structure’s ? Following are the key differences between the...
Can Multiple Cursors Being Opened at the Same Time? - Oracle DBA FAQ - Working with Cursors in PL/SQ...
What is Windows DNA architecture? Note :- If you have worked with classic ASP this question can come...
How To Divide Query Output into Groups? - MySQL FAQs - SQL SELECT Query Statements with GROUP BY You...