Interested to Buy Any Domain ? << Click Here >> for more details...
what is different between inline query,subquery& corelated
query?
- 8 Answers
- 106379 Views
- Quest, I also Faced
- E-Mail Answers
Answer Posted / dhana
A correlated subquery is a SELECT statement nested inside
another T-SQL statement, which contains a reference to one
or more columns in the outer query. Therefore, the
correlated subquery can be said to be dependent on the outer
query. This is the main difference between a correlated
subquery and just a plain subquery. A plain subquery is not
dependent on the outer query, can be run independently of
the outer query, and will return a result set. A correlated
subquery, since it is dependent on the outer query will
return a syntax errors if it is run by itself.
| Is This Answer Correct ? | 57 Yes | 16 No |
Post New Answer View All Answers
I need a Technical evaluation between Oracle and SAP ? please do a need ful.
can u pls share responsibilities for production how to environment in odi?and how to generate report ?
how to replace not in with not exist?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?
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?
Explain the difference between $ORACLE_HOME and $ORACLE_BASE.
Hi, IN oracle apps HRMS, if the employee changes his department, and when a conconurrent program is run for calulating the pay, The latest Dept id is not diaplayed, howeber the previous deptid is considered. Please can someone tell me where is the program going wrong, which side?
where the dff data will be stored
Tell me about entire study of finacle software as soon as possible? give me the idea about questions which coulb be asked in interview of pnb it officers?
as a technical developer in oracle applications which type errors feced in your experience sofar
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
i want to know about the javaBean.what is its purpose and how it can use in Forms.
How to clone the database using RMAN back
what is semphore explian it?
please send me oracle pl/sql exp resume. and also faqs...
