Difference between sub query and nested query ?
Answer Posted / nirvaya
A subquery is a query within a query. In Oracle, you can
create subqueries within your SQL statements. These
subqueries can reside in the WHERE clause, the FROM clause,
or the SELECT clause. Most often, the subquery will be
found in the WHERE clause. These subqueries are also called
nested subqueries.
Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
Is oracle a relational database?
How to start an oracle instance?
What are transaction isolation levels supported by oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
What are the advantages of oracle 12c?
How to shutdown your 10g xe server?
What is Virtual Private Database in Oracle?
What is the fastest query method to fetch data from the table?
Give the various rollback segment states.
What are the limitations oracle database 10g xe?
Difference between the “verify” and “feedback” command?
Is oracle an operator?
What is a database schema in oracle?
What is the relation of a user account and a schema?