Hi Friends, Query inside a query is called as Sub query. Sub query is

Difference between sub query and nested query ?

Question Posted / reddy

Answer Posted / reddy

Hi Friends,

Query inside a query is called as Sub query. Sub query is
also called as Nested Query.

Thanks
REDDY

Is This Answer Correct ?

22 Yes

41 No

Please Help Members By Posting Answers For Below Questions

what are the advantages of running a database in archive log mode?

2203

What is memory advisor in Oracle?

1077

How to define an anonymous procedure without variables?

1107

How to create a new table by selecting rows from another table?

1102

How to use attributes of the implicit cursor in oracle?

1008

Explain what are the characteristics of data files?

1085

IS it possible to built the oracle database without setting the kernal parameters?

2348

What language does oracle use?

1100

what is a Nested Loop join?

2113

What is a nvl function? How can it be used?

1031

Can a parameter be passed to a cursor?

1126

How to create a table in a specific tablespace?

976

What is the difference between 10g OEM and 11g OEM?

965

In what script is snap$ created? In what script is the scott/tiger schema created?

2708

What is a cursor variable?

1129