what is different between inline query,subquery& corelated
query?
Answer Posted / thulasidas kp
An inline view is a SELECT statement in the FROM-clause of
another SELECT statement. In-line views are commonly used
simplify complex queries by removing join operations and
condensing several separate queries into a single query.
This feature was introduced in Oracle 7.
| Is This Answer Correct ? | 11 Yes | 3 No |
Post New Answer View All Answers
What is the meaning of "Modulus" and "Alignment" in a datafile. Data file might be from any database. Data file is created through unloading data from a table. So, while loading this data into my table, I need to use these keywords. Could any one can help me regarding this?
how can we add a field to the oracle standard forms through Form Persanlization or custom.pll
now iam working as an hr executive in hyderabad i would like to learn oracle hrms kindly suggest me some good institutes in hyderabd
HOW TO SPOT AHIERARCHY?
hi iam kavya, i completed Oracle11i(finance module), i do not know how to face the interview questions please adivese me
as a technical developer in oracle applications which type errors feced in your experience sofar
I am Bsc Computer Science Graduate, I have good knowledge in SQL 7.0, Can I go for Oracle APPS course please suggest me the answer
Explain how to close periods in ar. : oracle accounts receivable
what are the API of GL,PO,AP
What Are Cross Validation & Adi?
which one is currently in used software cmpanies.
What is the use of lockboxes? Steps for lock box : oracle accounts receivable
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
Difference between negative and positive adjustments : oracle accounts receivable
difference of using cursor for loop and open,fetch,close.which one is better