CO-RELATED SUBQUERY
A CO-RELATED SUBQUERY is one that has a correlation name as table or view designator in the FROM clause of the outer query and the same correlation name as a qualifier of a search condition in the WHERE clause of the subquery.eg:SELECT field1 from table1 XWHERE field2>(select avg(field2) from table1 Y where field1=X.field1);
skip to main |
skip to sidebar
ORACLE DEVELOPER
Labels
- connect by prior (1)
- DECODE FUNCTION IN ORACLE (1)
- Difference between database triggers and form triggers? (1)
- Difference between procedure and function. (1)
- Differentiate between TRUNCATE and DELETE. (1)
- Eliminate duplicate rows from table (1)
- Second Largest Number (1)
- What are cursor attributes? (1)
Blog Archive
-
▼
2009
(15)
-
▼
June
(10)
- Eliminate duplicate rows from table
- DECODE FUNCTION IN ORACLE
- connect by prior
- CO-RELATED SUBQUERY
- To know the current week of the year
- Second Largest Number
- What are cursor attributes?
- Difference between procedure and function.
- Difference between database triggers and form trig...
- Differentiate between TRUNCATE and DELETE.
-
▼
June
(10)
Share
Recent Posts
Blogger Tricks
Blogger Themes
Tags
- connect by prior (1)
- DECODE FUNCTION IN ORACLE (1)
- Difference between database triggers and form triggers? (1)
- Difference between procedure and function. (1)
- Differentiate between TRUNCATE and DELETE. (1)
- Eliminate duplicate rows from table (1)
- Second Largest Number (1)
- What are cursor attributes? (1)
Download
Labels
- connect by prior (1)
- DECODE FUNCTION IN ORACLE (1)
- Difference between database triggers and form triggers? (1)
- Difference between procedure and function. (1)
- Differentiate between TRUNCATE and DELETE. (1)
- Eliminate duplicate rows from table (1)
- Second Largest Number (1)
- What are cursor attributes? (1)
0 comments:
Post a Comment