Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between the query and corelated
query
- 8 Answers
- 20749 Views
- HSBC, IBM, TCS, Xenosoft, I also Faced
- E-Mail Answers
Answer Posted / aravinda
query: query is single time validation of conditions for
entire result once result is fetched there no further
validation of records.
corelated sub query : each record is validated with inner
query aftr fetch.
1) outer query will execute first and pass a value to inner
query.
2) based on outer query value inner query will execute.
3) based on inner query value the outer query record will be
validated.
inner query will execute for every record of outer query( if
outer query has 10 records inner query will execute 10 times)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is output spooling in sql*plus?
Why do we use function in pl sql?
What is sql exception?
What is an intersect?
What is the difference between between and in condition operators?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?
Are stored procedures compiled?
How to use distinct and count in sql query? Explain
How to run sql*plus commands in sql developer?
What is data modelling in sql?
What is the difference between microsoft sql and mysql?
what is a stored procedure? : Sql dba
Define join and name different types of joins?
Why are aggregate functions called so?
What is a sql driver?
