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 get execution statistics reports on query statements?
How to store only time; not date and time?
How to change user password in oracle?
What are the common oracle dba tasks?
How to divide query output into groups in oracle?
How to end the current transaction in oracle?
What are the restrictions in a oracle read only transaction?
Is it possible to split the print reviewer into more than one region ?
What are the types of partitions in oracle?
What are the uses of a database trigger?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
What is memory advisor in Oracle?
What is primefaces used for?
What happens if you use a wrong connect identifier?
What is the simplest tool to run commands on oracle servers?