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

Answer Posted / thulasidas kp

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 ?    11 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of table functions.

1792


HOW TO SPOT AHIERARCHY?

1847


What is auto invoicing? Explain : oracle accounts receivable

610


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

1248


What is supporting issues GL AP and AR?

1980






Where in the Oracle directory tree structure are audit traces placed?

2118


3. Steps in UAT?

1945


What is the mandatory setup in cyclecount ?

2180


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1769


what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these

1827


how to write customizations in po

1193


WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

2386


Are These Dff's Flexible?

731


please send me oracle pl/sql exp resume. and also faqs...

2036


How would you determine what sessions are connected and what resources they are waiting for?

1610