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
How to create a table in a specific tablespace?
What are nested tables?
Explain enable novalidate constraint.
What is an Oracle index?
Can you drop an index associated with a unique or primary key constraint?
What is a select query statement in oracle?
Explain the use of owner option in exp command.
What is oracle data type?
What is meant by joins? List out the types of joins.
How to define default values for formal parameters?
What is Segment Advisor in Oracle?
What is the order of defining local variables and sub procedures/functions?
What are the limitations oracle database 10g xe?
How to count groups returned with the group by clause in oracle?
Can objects of the same schema reside in different tablespace?