what is correlated subquery
Answers were Sorted based on User's Feedback
Answer / g.v.prasad
It is Another Way of Performing queries upon the data with a
simulation of joins
in this the information from the OUTER SELECT statement
participates as a condition in the INNER SELECT statement
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ruba
outer query is first executed and then outerquery was used
by the inner query
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / naveen
Inner Query refers outer query refers inner Query
we can take an example of Inline View
Is This Answer Correct ? | 0 Yes | 2 No |
How do you use trigger to create mutating state of table
What is auto accounting what are the steps for setting up auto accounting? : oracle accounts receivable
HOW TO SPOT AHIERARCHY?
What are the standard concurent programs for auto invoice interface and customer interfaces? : oracle accounts receivable
How would you go about increasing the buffer cache hit ratio?
Difference between transaction type and transaction sources. : oracle accounts receivable
Explain how to account for bank charges deducted from amount received against an invoice. : oracle accounts receivable
What are the interface tables used for ar invoices, customers, receipts for conversion process? : oracle accounts receivable
What is the architectural difference between Oracle and SQL Server 2000? If I have 100 databases, how many instances get created when you use Oracle and how many get created when you use SQL Server?
Why we are using primary key and foreign key in oracle and difference between primary key and foreign key?
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?
Explain accounting for invoice in advance and arrears. : oracle accounts receivable