Oracle Discussion Forums
Welcome, Guest. Please login or register.
September 07, 2010
Home Help Search Login Register
News:


+  WebForums - OraclePassport
|-+  IT progamming - Oracle, Java, Unix, MySQL, Toad
| |-+  Oracle Basics
| | |-+  What are Nested and Correlated subqueries ? 		0 Members and 1 Guest are viewing this topic. « previous next »
Pages: [1] Go Down Send this topic Print
Author Topic: What are Nested and Correlated subqueries ?  (Read 897 times)
dtech-team
Administrator
Assistant Professor
*****

Appreciate? +5/-0
Offline Offline

Posts: 616


DTecH Oracle Forums

WWW
« on: October 08, 2009 »
What are Nested and Correlated subqueries ?
Report to moderator   Logged

DTecH Admin Team
Buy Oracle Interview Preparations Kit from DTecH IT Education - 250 Oracle Interview Questions and Answers.
dtech-team
Administrator
Assistant Professor
*****

Appreciate? +5/-0
Offline Offline

Posts: 616


DTecH Oracle Forums

WWW
« Reply #1 on: October 08, 2009 »
- The subquery used in WHERE clause is a nested subquery.

- If this subquery refers to any column in the parent statement, it becomes a correlated subquery.
Report to moderator   Logged

DTecH Admin Team
Buy Oracle Interview Preparations Kit from DTecH IT Education - 250 Oracle Interview Questions and Answers.
Pages: [1] Go Up Send this topic Print 
« previous next »
 
Share this topic...
In a forum
(BBCode)
In a site/blog
(HTML)



Login with username, password and session length

Powered by MySQL Powered by PHP Powered by SMF 2.0 RC1.2 | SMF © 2006–2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!
Page created in 0.138 seconds with 19 queries.