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

How to write a query with a left outer join in oracle?

1065

11. Display the client number and name and the client number and name of the person who referred that client.

2339

How to drop an existing view in oracle?

946

what is the difference between substr and instr function in oracle?

1090

What are the parameters that we can pass through a stored procedure?

1064

What is the difference between "as" and "is" in an oracle stored procedure?

991

In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?

2286

How does oracle handle read consistency?

1097

How to use "in" parameter properly?

1071

What is oracle in java?

969

What do you understand by a database object? Can you list a few of them?

1018

How to connect to the server with user account: sys?

1019

What is Reduced List of Values?

2165

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

2144

How to connect the oracle server as sysdba?

1077