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
How to retrieve data from an explicit cursor?
how may join possible between (requisition with purchase order)
How index is implemented in oracle database?
How many types of database triggers exist?
How to end the current transaction in oracle?
How to rename an existing table?
What is oracle rownum?
Can select statements be used on views in oracle?
How to create a new table by selecting rows from another table?
What is an oracle data file?
How will you identify oracle database software release?
How to experiment a data lock in oracle?
What are the different types of partitions in oracle?
What is sharded cluster?
What is MTTR advisor in Oracle?