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

Answer Posted / madhavi

A subquery is a query (usually enclosed by parentheses)
that appears within another
SQL data manipulation statement. When evaluated, the
subquery provides a value
or set of values to the statement. Often, subqueries are
used in the WHERE clause.
Whereas a subquery is evaluated only once for each table, a
correlated subquery is
evaluated once for each row.
An inline query or inline view is the query whichis in from
clause of select statement

Is This Answer Correct ?    44 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an Oracle database Full Backup?

634


as a technical developer in oracle applications which type errors feced in your experience sofar

1777


What is supporting issues GL AP and AR?

1993


How would you go about increasing the buffer cache hit ratio?

1957


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

2040






I need a Technical evaluation between Oracle and SAP ? please do a need ful.

1495


what ASIS BUSINESS PROCESS IN ORACLE FINANCE

1772


What are the different tools available for hot backups in Oracle? Is it preferable to take it manually all the time or it depends on the size of the database?

706


What is the mandatory setup in cyclecount ?

2192


where the dff data will be stored

1804


Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.

1850


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

1835


PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE

1703


Differentiate between writeoff and receipt writeoff. : oracle accounts receivable

740


What is the use of lockboxes? : oracle accounts receivable

659