what is correlated subquery
Answers were Sorted based on User's Feedback
Answer / g.v.prasad
It is Another Way of Performing queries upon the data with a
simulation of joins
in this the information from the OUTER SELECT statement
participates as a condition in the INNER SELECT statement
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ruba
outer query is first executed and then outerquery was used
by the inner query
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naveen
Inner Query refers outer query refers inner Query
we can take an example of Inline View
Is This Answer Correct ? | 0 Yes | 2 No |
Olap tools
Explain the difference between a hot backup and a cold backup and the benefits associated with each
How to find locks exists in a table or not?
i am having comm in emp table and i want to display 0 when comm =null and -10 if comm= value
What is Restricted Mode of Instance Startup in Oracle?
What command would you use to encrypt a PL/SQL application?
What is the difference between conversions and interfaces? : oracle accounts receivable
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
3. Steps in UAT?
Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?
What is the difference between oracle media recovery and crash recovery?
we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.