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
Why does oracle 9i treat an empty string as null?
How to insert a record into a table?
what is dynamic SGA and static SGA
In not less than 100 words what's the main difference between Rolap and Molap in ORACLE ?
Can we create trigger on materialized view in oracle?
Explain an index?
How to define an external table with a text file?
Using the relations and the rules set out in the notes under each relation, write statements to create the two sequence generators specified in the notes.
What is Library Cache in Oracle?
Explain the use of indexes option in exp command.
What is an oracle data file?
How to write a left outer join with the where clause in oracle?
How index is implemented in oracle database?
What is logical backup in oracle?
How to assign a table row to a record variable?