Interested to Buy Any Domain ? << Click Here >> for more details...
what is different between inline query,subquery& corelated
query?
- 8 Answers
- 106315 Views
- Quest, I also Faced
- E-Mail Answers
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 are different types of receipt reversals ? Explain them : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
default triggers available for reports
How would you determine who has added a row to a table?
can we use lexical perameter in oracle plsql if yes how
Explain prerequisites and post activities of oracle database installation
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
What Are Cross Validation & Adi?
What do you mean by Oracle MEDIA RECOVERY?
8. Supporting AP, AR and GL?
What is the importance of batch source set up in ar? : oracle accounts receivable
what are all the conversion and interfaces in GL,AP,AR,HRMS with example? otherwise send send link for these
What is auto invoicing? : oracle accounts receivable
How would you determine what sessions are connected and what resources they are waiting for?
What is auto invoicing? Explain : oracle accounts receivable
