Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to decide that we should use correlated subquery?

2676038Jun 7 2016 — edited Jun 7 2016

Hi Team,

I am new to sql query,

When can we go for correlated subquery,, in what situtation we should use correlated?

Second how correlated subquery works, as far as know subquery is executed on each iteration of main query.. Can you please elaborate it with example...


So that it will be clear to me..



Regards

Inam

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2016
Added on Jun 7 2016
5 comments
739 views