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 |
Name three advisory statistics you can collect.
How would you force a log switch?
how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.
whats the difference between join command and Cartesian product using example?
How to clone the database using RMAN back
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
what is the querry to get first 10 records from the emp table?(emp no is the primary key)
can u tell me how many types of oracle and which type all detail in oracle (suppose all history of oracle )
Hi I am searching for best oracle Apps institute? Please tel me which is best institute in hyderabad I am working in developer 6i....
What view would you use to determine free space in a tablespace?
What is the difference between conversions and interfaces? : oracle accounts receivable
What is the use of lockboxes? : oracle accounts receivable