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
What is memory advisor in Oracle?
What do you understand by database schema and what does it hold?
How to calculate date and time differences in oracle?
What is a relational database management system?
List the parts of a database trigger.
What happens if the update subquery returns multiple rows?
What is the Tune Query
Which environment variables are absolutely critical in order to run the OUI?
Explain the use of online redo log files in oracle.
How to check database size in Oracle?
What is the difference between formal parameters and actual parameters?
What is a data dictionary and how can it be created?
Explain about achiever in sql?
What is the oracle implicit cursor?
How to lock and unlock a user account in oracle?