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

What is a trace file and how is it created in oracle?

986

Can we write insert statement in function in oracle?

1035

Explain the use of record option in exp command.

952

How to drop an index in oracle?

1025

How to connect to a remote server?

1063

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

2148

nw i'm doing MBA system and planning to do oracle,database management.tell me that whether it is useful r not?.refer any course for my carrier pls

2154

What is dual table oracle?

932

Explain the characteristics of oracle dba?

1071

Explain about achiever in sql?

981

How to get a list of all user accounts in the database?

1037

Explain mutating triggers.

978

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2192

Difference between inner join vs where ?

986

State and explain about oracle instance?

938