Difference between sub query and nested query ?
- 19 Answers
- 62407 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 IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
What is Data Dictionary Cache in Oracle?
What is a dead lock in oracle?
Where do you use decode and case statements?
What is an oracle cursor variable?
What is concurrency in oracle?
How would you edit your CRONTAB to schedule the running of /test/test.sh to run every other day at 2PM?
Explain the blob datatype?
What happens to the current transaction if the session is ended?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to pass parameters to procedures in oracle?
What are the roles of dba?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How can Oracle users be audited?
Is oracle the best database?
