Difference between sub query and nested query ?
- 19 Answers
- 64791 Views
- Keane India Ltd, TCS, I also Faced
- E-Mail Answers
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 to put more than 1000 values into an oracle in clause?
How do I know if oracle is installed on windows?
How to retrieve values from data fields in record variables?
How to delete a column in an existing table in oracle?
Explain the use of constraints option in exp command.
What are the restrictions on external table columns?
Which is faster join or subquery in oracle?
How to rename a tablespace in oracle?
What is the difference between $oracle_base and $oracle_home?
Can we store pictures in the database and if so, how it can be done?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
Will you be able to store pictures in the database?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How would you go about verifying the network name that the local_listener is currently using?
How to apply filtering criteria at group level in oracle?
