Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 68543 Views
- Keane India Ltd, TCS, I also Faced
- E-Mail Answers
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 many types of tables are there in oracle?
What is an oracle database?
various types of hints and their usage
How to write numeric literals in oracle?
What happens if you lost a data file?
How can I see all tables in oracle?
How to save query output to a local file?
What is translate in oracle?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
How to use subqueries with the exists operator in oracle?
How to find the duplicate rows count from employees table in oracle?
What is the simplest tool to run commands on oracle servers?
Does oracle charge for java?
How to start an oracle instance?
What is the data type of dual table?
