Difference between sub query and nested query ?
Answer Posted / dinesh sahoo
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 ? | 12 Yes | 9 No |
Post New Answer View All Answers
What are the uses of linked server and explain it in detail?
How would you begin to troubleshoot an ORA-3113 error?
What are operators in oracle?
What is a connect identifier?
What happens to the current transaction if a ddl statement is executed?
What are triggers in oracle?
How to shutdown your 10g xe server?
WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?
How to recover a dropped table in oracle?
How do I find the database name in oracle?
What are the different editions of oracle?
Explain enable novalidate constraint.
What is a procedure in oracle?
How would you best determine why your MVIEW couldnt FAST REFRESH?
What is a data dictionary and how can it be created?