Difference between sub query and nested query ?
- 19 Answers
- 65374 Views
- Keane India Ltd, TCS, I also Faced
- E-Mail Answers
Answer Posted / mohanty
query inside the query is nested query.
it is also called as sub query.
Correlated subquery runs once for each row selected by the
outer query. It contains a reference to a value from the
row selected by the outer query.
Nested subquery runs only once for the entire nesting
(outer) query. It does not contain any reference to the
outer query row.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
please explain.. DB architecture ...
What is partitioned table in Oracle?
How to convert characters to times in oracle?
How to assign a tablespace to a users in oracle?
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
What is a dynamic performance view in oracle?
What is tns service name?
How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.
How do I use unicode codesets with the weblogic jdriver for oracle driver?
can anyody please send me the dump for Oracle 10g certifications for DBA path?
What are the uses of synonyms?
What is oracle join syntax?
How to write numeric literals in oracle?
How to create a table interactively?
Use of an integrity constraint is better to validate data. Explain
