Interested to Buy Any Domain ? << Click Here >> for more details...
Difference between sub query and nested query ?
- 19 Answers
- 67613 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
What are the logical operations?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
Explain the use of parfile option in exp command.
Can you assign multiple query result rows to a variable?
Is there a function to split a string in plsql?
How to use "while" statements in oracle?
What are the various constraints used in oracle?
How to create a new table in your schema?
Write a syntax for update query in oracle?
Can we store pictures in the database and if so, how it can be done?
How to define an oracle sub procedure?
Why use resource manager in Oracle?
What is an external table?
How to load data from external tables to regular tables?
How will you differentiate between varchar & varchar2?
