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

What is memory advisor in Oracle?

850


What do you understand by database schema and what does it hold?

970


How to calculate date and time differences in oracle?

810


What is a relational database management system?

900


List the parts of a database trigger.

822


What happens if the update subquery returns multiple rows?

855


What is the Tune Query

2100


Which environment variables are absolutely critical in order to run the OUI?

1936


Explain the use of online redo log files in oracle.

817


How to check database size in Oracle?

889


What is the difference between formal parameters and actual parameters?

776


What is a data dictionary and how can it be created?

855


Explain about achiever in sql?

827


What is the oracle implicit cursor?

833


How to lock and unlock a user account in oracle?

878