what is the difference between the query and corelated
query
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
Is keyword pl sql?
What is the difference between the conventional and direct path loads? : aql loader
Is t sql a programming language?
What is sql*plus?
What is where clause in sql?
How long it takes to learn pl sql?
What is the use of non clustered index?
Define union, minus, union all, intersect ?
Can you rollback after commit?
What does seeding a database mean?
What can you do with pl sql?
Enlist some predefined exceptions?
Why do we use function in pl sql?
what are the advantages of using stored procedures? : Sql dba
How many types of index are there?