what are corelated subqueries
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 |
Point out the difference between user tables and data dictionary?
How are extents allocated to a segment?
How view is different from a table?
select * from emp what happened internally when we write this query in the sql prompt?
What happens if variable names collide with table/column names?
which language is used to develop the oracle........?
How to pass parameters to procedures?
How oracle handles dead locks?
What are the restrictions in a oracle read only transaction?
Which is better Oracle or MS SQL? Why?
What are the components of Logical database structure of ORACLE database?
Can u make a synonym for deptno=10 only from emp table.