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 |
Explain the use of rows option in imp command.
For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?
How is it different from a normal table?
How can I create database in oracle?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
How oracle handles dead locks?
How will you differentiate between varchar & varchar2?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
how to truncate date and get only time part 9:20:00
how to delete all duplicate records from a table using subquery?
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
How to bring a tablespace online?