Difference between sub query and nested query ?
Answer Posted / s.maheshbabu
quarry inside a quarry is called sub quarry.when sub quarry
is also called nested quarry.
co-related sub quarry is one as inner quarry is evaluated.is
anther result of inner are evaluated.
nested quarry is multiple time of one outer quarry.
ex;-quarry used in()caused co-related quarry.
quarry used with=operator is nested quarry.
| Is This Answer Correct ? | 0 Yes | 3 No |
Post New Answer View All Answers
How to get execution statistics reports on query statements?
What is tns name?
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
What is a cognitive schema?
What is oracle and what are its different editions?
How to run create database statement?
What is ceil and floor in oracle?
How to define an oracle cursor variable?
What is meant by an index?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
How to view existing locks on the database?
 How to use an oracle sequence generator in a mapping?
What privilege is needed for a user to query tables in another schema?
Can we connect to ORACLE db using Windows Authentication?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?