Sunbquery is a query within a query where as Nested query is a subquery w

Difference between sub query and nested query ?

Question Posted / sravzzz

Answer Posted / sravzzz

Sunbquery is a query within a query where as Nested query
is a subquery which resinde in the WHERE clause.

Is This Answer Correct ?

12 Yes

15 No

Please Help Members By Posting Answers For Below Questions

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

1094

You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

2061

What are nested tables?

1222

State any two functions of oracle?

1090

what is difference between sql plus and sql*plus? (not sql and sql plus).

3939

How to filter out duplications in the returning rows using oracle?

1064

How many types of segments in Oracle?

1114

What are the ways tablespaces can be managed and how do they differ?

2440

How to call a stored function in oracle?

1061

Name the three major set of files on disk that compose a database in Oracle?

1170

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2188

What is system global area (sga) in oracle?

1031

Is oracle an open source?

1122

How to define a sub function?

1195

What are the differences between lov and list item?

1138