Difference between sub query and nested query ?

Answer Posted / nirvaya

A subquery is a query within a query. In Oracle, you can
create subqueries within your SQL statements. These
subqueries can reside in the WHERE clause, the FROM clause,
or the SELECT clause. Most often, the subquery will be
found in the WHERE clause. These subqueries are also called
nested subqueries.

Is This Answer Correct ?    9 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why does oracle 9i treat an empty string as null?

745


How to insert a record into a table?

836


what is dynamic SGA and static SGA

4061


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

2015


Can we create trigger on materialized view in oracle?

767


Explain an index?

884


How to define an external table with a text file?

810


Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.

1871


What is Library Cache in Oracle?

847


Explain the use of indexes option in exp command.

779


What is an oracle data file?

836


How to write a left outer join with the where clause in oracle?

837


How index is implemented in oracle database?

779


What is logical backup in oracle?

781


How to assign a table row to a record variable?

768