Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 68572 Views
- Keane India Ltd, TCS, I also Faced
- E-Mail Answers
Answer Posted / roshan
ONE THING I WOULD LIKE TO TELL.. SUBQUERY RUNS MUCH FASTER
THAN CO-RELATED QUERY..
BECAUSE EACH TIME IT HAS TO COMPARE THE OUTER QUERY IS
EVALUATED EACH TIME............
| Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
How to update values on multiple rows in oracle?
What is SQL access advisor in Oracle?
How many categories of data types?
What is an oracle tablespace?
How do I find my oracle client driver version?
How to see free space of each tablespace?
How to define a specific record type?
Can we store pictures in the database and if so, how it can be done?
What is the order of defining local variables and sub procedures/functions?
Explain what are clusters?
How to create a server parameter file?
What are a query and state the different types of queries and their uses?
What is ordinary table in oracle?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
How to delete a column in an existing table?
