What is the difference between normal and corelated subqueries?
Answer Posted / deva
corelated subquery is the one where the in-query takes the
input from the outer query. This happens for every value in
the in-query.
| Is This Answer Correct ? | 12 Yes | 2 No |
Post New Answer View All Answers
Explain what are clusters?
How to convert a string to a date in oracle database?
How to select an oracle system id (sid)?
Explain what are the type of synonyms?
How to establish administrator authentication to the server?
What is the fastest query method to fetch data from the table?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
What is a nested table and how is it different from a normal table?
Explain what are synonyms used for?
how to handle exceptions in post production
What is a snapshot log?
How to change program global area (pga) in oracle?
Explain the use of ignore option in imp command.
What are the limitations of check constraint?
What happens in oracle commit?