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
Oracle
How to get last row id?
How to create a new tablespace in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is a subquery?
how to handle exceptions in post production
Is oracle a relational database?
Difference between inner join vs where ?
What is background process in Oracle?
How to loop through data rows in the implicit cursor?
Explain oracle’s server parameter file.
How to select some rows from a table in oracle?
What are the components of logical database structure in oracle database?
Explain the use of record option in exp command.
How translate command is different from replace?