what is different between inline query,subquery& corelated
query?

Answer Posted / dhana

An inline view is a SELECT statement in the FROM-clause of
another SELECT statement. In-line views are commonly used
simplify complex queries by removing join operations and
condensing several separate queries into a single query.
This feature was introduced in Oracle 7.

Is This Answer Correct ?    79 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable

899


what are basic modules required to implement oracle application in any oraganisation?

1953


what are the API of GL,PO,AP

1997


difference of using cursor for loop and open,fetch,close.which one is better

1483


can u pls share responsibilities for production how to environment in odi?and how to generate report ?

2133


How many segment are present in Oracle Manufacturing

2050


Can you explain how to adjust the amount of advance already received against an invoice? : oracle accounts receivable

999


Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?

2600


TILL WHAT LEVEL OF SECURITY BO SUPPORTS?

3195


What is the difference between oracle media recovery and crash recovery?

897


8. Supporting AP, AR and GL?

2059


HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

1817


What is the sql query to find the employee who has Nth maximum salary?

4730


WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?

1789


how to replace not in with not exist?

3391