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

Differentiate between earned discounts and unearned discounts? : oracle accounts receivable

674


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

2040


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

1835


what are the interface and api table for receipts conversion in oracle receivables? : oracle accounts receivable

645


What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable

628






default triggers available for reports

1761


What is the mandatory setup in cyclecount ?

2192


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1772


where the dff data will be stored

1804


How I can load an image into image item on Forms. I want to know about built-ins and procedure. and also code for it.

1633


Explain accounting for invoice in advance and arrears. : oracle accounts receivable

625


we have 10 concurrent programs under one request group out of 10 ccps all users submitting only 9 programs from srs window remaining one ccp for specific user how can it possible send me answer asap.

1879


1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?

1654


i want to know about the javaBean.what is its purpose and how it can use in Forms.

1835


What is autocashrule set? : oracle accounts receivable

743