Difference between sub query and nested query ?
Answer Posted / s.maheshbabu
quarry inside a quarry is called sub quarry.when sub quarry
is also called nested quarry.
co-related sub quarry is one as inner quarry is evaluated.is
anther result of inner are evaluated.
nested quarry is multiple time of one outer quarry.
ex;-quarry used in()caused co-related quarry.
quarry used with=operator is nested quarry.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
Explain the difference between sql and oracle?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
How to create an oracle database manually?
What are the execution control statements?
How do I learn what codesets are available in oracle?
What is the difference between a user and a schema in oracle?
What are the logical operations?
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
What is oracle update statement with inner join ?
How to see the table columns used in an index?
Compare and contrast between sql and sql server and explain its various functions?
Difference between inner join vs where ?
Why do we need integrity constraints in a database?
Can we create database in oracle using command line ?