what are corelated subqueries
- 1 Answers
- 2187 Views
- Global Infotech, I also Faced
- E-Mail Answers
Answer / anonymus
In a SQL database query, a correlated subquery (also known as a synchronized subquery) is a subquery (a query nested inside another query) that uses values from the outer query. Because the subquery may be evaluated once for each row processed by the outer query, it can be inefficient.
| Is This Answer Correct ? | 0 Yes | 0 No |
Difference between inner join vs where ?
What is an Oracle view?
How to bring a tablespace online?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Describe an oracle table?
difference between imlicit cursor and explicit cursor ?
What are the differences between lov and list item?
What is Hash Cluster ?
What are the factors causing the reparsing of SQL statements in SGA?
How to restrict the duplicate records in table valuesets
find out the third highest salary?
92 Answers CIPL, Cyber Shot, HCL, Hewitt, IBM, JPMorgan Chase, Orion, Verizon,
How to put more than 1000 values into an oracle in clause?
Oracle General 
