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

Describe varray?

586


What are the various constraints used in oracle?

556


What is the fastest query method to fetch data from the table?

863


What are the different pseudo commands? Explain in general?

539


i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?

1470






How to bring a tablespace online?

518


How to create a temporary table in oracle?

694


What happens if you use a wrong connect identifier?

503


Explain the importance of .pll extension in oracle?

553


How to define an oracle cursor variable?

567


Can a parameter be passed to a cursor?

600


How to create an oracle testing table?

591


Give the constructs of a package, function or a procedure.

540


What are the types of trigger in oracle?

573


How to create a server parameter file?

571