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
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
can u give guidance abt packages of plsql
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
Difference between transaction type and transaction sources. : oracle accounts receivable
What is auto invoicing? : oracle accounts receivable
How to move the data from one flatfile to multiple staging tables?give me some examples? for example in po interface one flat file is there and multiple staging tables are there how can move it?please give me answer for this question?
8. Supporting AP, AR and GL?
PURCHASE ORDER TO PAYABLES WHAT ENTREIS WILL HAVE
What Are Cross Validation & Adi?
What are the advantages of operating a database in ARCHIVELOG mode over operating it in NO ARCHIVELOG mode in Oracle?
3. Steps in UAT?
What is an Oracle database Full Backup?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?