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
What is an Oracle database Full Backup?
as a technical developer in oracle applications which type errors feced in your experience sofar
What is supporting issues GL AP and AR?
How would you go about increasing the buffer cache hit ratio?
please send me oracle pl/sql exp resume. and also faqs...
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
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?
What is the mandatory setup in cyclecount ?
where the dff data will be stored
Hey i want to join oracle apps so will you pls tell me that which institute is best in hyderabad.
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
Differentiate between writeoff and receipt writeoff. : oracle accounts receivable
What is the use of lockboxes? : oracle accounts receivable