Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
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, 4980👍, 0💬
Popular Posts:
What is difference between Association, Aggregation and Inheritance relationships? In object oriente...
How can I execute a PHP script using command line? Just run the PHP CLI (Command Line Interface) pro...
How can you check to see whether a symbol is defined? You can use the #ifdef and #ifndef preprocesso...
How To Use "IN OUT" Parameter Properly? - Oracle DBA FAQ - Creating Your Own PL/SQL Procedures and F...
Describe different elements in Static Chart diagrams ? Package: - It logically groups element of a U...