corelated subquery is the one where the in-query takes the input from the

What is the difference between normal and corelated subqueries?

Question Posted / deva

Answer Posted / deva

corelated subquery is the one where the in-query takes the
input from the outer query. This happens for every value in
the in-query.

Is This Answer Correct ?

12 Yes

2 No

Please Help Members By Posting Answers For Below Questions

Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables

1996

What is a trigger and what are its types?

1113

How to run queries on external tables?

987

What is a nested table?

1004

How to create lov dynamically at runtime & attach to text field?

1097

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

2183

How to delete all rows a table in oracle?

1008

How can I see all tables in oracle?

949

What is an oracle tablespace?

982

Explain the use of tables option in exp command.

1051

What is not equal to in oracle?

951

What is the maximum number of triggers that can be applied to a single table?

954

How to convert characters to numbers in oracle?

998

What is an Oracle Instance?

1070

Is oracle a programming language?

935