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 is the difference between substr & instr functions?
What is SQL access advisor in Oracle?
Is rowid unique in oracle?
What is concurrency in oracle?
What is a sub query and what are the different types of subqueries?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
What happens if the update subquery returns multiple rows?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
How to use group functions in the select clause using oracle?
What is define in oracle?
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is data file?
How to convert csv to table in oracle?
Give the various rollback segment states.
What is the usage of control file in oracle?