Interested to Buy Any Domain ? << Click Here >> for more details...
what is different between inline query,subquery& corelated
query?
- 8 Answers
- 106748 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 do you mean by Oracle MEDIA RECOVERY?
What is the use of lockboxes? : oracle accounts receivable
difference of using cursor for loop and open,fetch,close.which one is better
What is an Oracle database Full Backup?
where the dff data will be stored
Is there any link between pr form(purchse requisition)and po form(purchase order)
What is mrc and what is its use? : oracle accounts receivable
How would you determine who has added a row to a table?
What is the use of transaction flexfield in autoinvoice? : oracle accounts receivable
What is auto invoicing? Explain : oracle accounts receivable
HOW TO GET THE ORGANIZATION TO ORGANIZATION DETAILS INFORMATION IN THE INVENTORY MODULE.THE REQUIREMENT IS FROMORG TOORG FROMINV TOINV ..
How do you create a credit note against an invoice? : oracle accounts receivable
1)After defining value set we define list of values, I need to enter 1000 values with out entering manually, how will you do that? 2)what are the parameters we use in a concurrent program? 3)what is payroll processing? 4)In organization window after defining an organization and organization classification how to create a new item in the others button? 5)If there are 10 users, How to restrict the selected users not to access the forms?
WHAT ARE TEMPLATES?EXPLAIN WHAT YOU HAVE CREATED?
What is the Difference between the Person_Type_id column in the per_all_people_f and per_person_type_usages_f
