Thats right , a co-related subquery is evaluated once for every row proc

What is correlated sub-query?

Question Posted / his highness abdullah!!

Answer Posted / his highness abdullah!!

Thats right , a co-related subquery is evaluated once for
every row processed by the parent statement.......

Is This Answer Correct ?

32 Yes

8 No

Please Help Members By Posting Answers For Below Questions

how to extract a unit value from a date and time? : Sql dba

991

What is the meaning of disabling a trigger?

1182

what is a foreign key ? : Sql dba

1084

How are functions and procedures called in PL/SQL?

1231

difference between anonymous blocks and sub-programs.

1138

How do I save a sql query?

1015

Explain normalization and what are the advantages of it?

953

What is user in sql?

1025

Which is better stored procedure or query?

957

Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints

1075

what are properties of a transaction? : Sql dba

1094

What is the difference between left join and right join?

946

Explain the purpose of %type and %rowtype data types with the example?

995

Why use subqueries instead of joins?

1081

Can I copy :old and :new pseudo-records in/to an oracle stored procedure?

1209