Interested to Buy Any Domain ? << Click Here >> for more details...
what is different between inline query,subquery& corelated
query?
- 8 Answers
- 107005 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
can u give guidance abt packages of plsql
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
i want to know about the javaBean.what is its purpose and how it can use in Forms.
Give two methods you could use to determine what DDL changes have been made.
1.In a table Gender is a column in that male and female are the two data.In a single statement i have to modify all male to female and all female to male vice versa. 2.In a single query i need the count of male data,count of female and total count
What is chargeback invoice? How do we create it? : oracle accounts receivable
Differentiate between transaction type and transaction source? : oracle accounts receivable
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What view would you use to determine free space in a tablespace?
Which is the best institute in Hyderabad to learn OBIEE and DataStage?Please tell me faculty name also
what are the types of LIST REPORTS in cognos8BI? and what is the mean and use of METRIC STUDIO in Cognos 8.3BI?
which one is currently in used software cmpanies.
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.
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?
what ASIS BUSINESS PROCESS IN ORACLE FINANCE
