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 |
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
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.
What is the difference between recovery and restoring of the oracle database?
what is debit memo and credit memo in AR?
Give the reasoning behind using an index.
I have 3+ Years experience HR with Technical Recruitment Industry. Now i would like to learn oracle HRMS Models of all aspect. please suggest any one, which institution is best for oracle HRMS practical with real time teaching in Chennai, Tamilnadu. What are the basic stat up to learn Oracle HRMS with Core strongly?
What background process refreshes materialized views?
WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGN UNIVERSES?
How to clone the database using RMAN back
how to write a query without using where? Example- select * from employee where empno=10 I need to write this query without where clause.
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?
while creating requisitions i am unable to see the list of organisation can anyone help me out ?