Difference between sub query and nested query ?
Answer Posted / roopesh kumar
Main Diff. b/w Subquery & Nested Subquery:
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.
| Is This Answer Correct ? | 25 Yes | 36 No |
Post New Answer View All Answers
How do I reset a sequence in oracle?
Differentiate between post-database commit and post-form commit?
How to insert a new row into a table in oracle?
How to drop a tablespace?
How to install oracle database 10g xe?
How to use attributes of the implicit cursor in oracle?
How to use fetch statement in a loop?
What is oracle sid?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
What is max rowid in oracle?
How to rollback the current transaction in oracle?
How to calculate date and time differences in oracle?
What is the difference between PFILE and SPFILE in Oracle?
How to drop an existing table in oracle?
How to define default values for formal parameters?