Sunday, February 5, 2012

what is the difference between nested query and correlated query in oracle?

In nested query, sub query is executed first and then result will be pushed to the main query where clause.
whereas in correlated query is quite opposite. For each row returned by the main query, sub query will be executed.

No comments:

Post a Comment