Difference between sub query and nested query ?

Answer Posted / rk

Hi all , My kind request is before jumping out and write the
answers. please check it whether , ur answer is correct.
Becos, most of the ppl. prepare for the interview with your
Answers.

In this thread , the answer given by "Vrushali" is totally
WRONG....
please don't mislead the ppl, with ur misunderstanding!!

cheers
RK.

PS: i don't want to hurt anyone ,,,, please think abt. this ...

Is This Answer Correct ?    67 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is object data modeling?

507


How to define and use table alias names in oracle?

511


What is MTTR advisor in Oracle?

610


How to turn on or off recycle bin for the session?

610


What are named parameters?

616






How a tablespace is related to data files?

583


How do we get field detail of a table?

627


What do you mean by merge in oracle?

593


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.

1704


How do I use os authentication with weblogic jdriver for oracle and connection pools?

577


What types of joins are used in writing subqueries?

569


What are the major difference between truncate and delete?

519


How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1469


Explain a data segment?

650


What is the difference between substr and instr?

521