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 |
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
How to write a query with a full outer join in oracle?
How to write a query with a left outer join in oracle?
Is postgres faster than oracle?
How to create a testing table in oracle?
Explain the use of ignore option in imp command.
What are the different types of failures that occur in Oracle database?
22. Display the order number, number of lines in the order, total number of items and total value for all orders that have a total value greater than $100
What is a nvl function?
emp numb is unique because that is primary key,,but what is foreign key .. explain very clear with example
How to turn on or off recycle bin for the instance?
How to call a stored function in oracle?