Difference between sub query and nested query ?

Answer Posted / mohammed al-fahed

The query inside a query is known as a subquery.
When we have another query again query inside subquery then
it is known as nested subquery, which resinde in the WHERE
clause.

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to retrieve data from an explicit cursor?

571


how may join possible between (requisition with purchase order)

1712


How index is implemented in oracle database?

604


How many types of database triggers exist?

590


How to end the current transaction in oracle?

574






How to rename an existing table?

619


What is oracle rownum?

526


Can select statements be used on views in oracle?

600


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

563


What is an oracle data file?

623


How will you identify oracle database software release?

536


How to experiment a data lock in oracle?

605


What are the different types of partitions in oracle?

508


What is sharded cluster?

534


What is MTTR advisor in Oracle?

620