It can be used Using REF CURSOR only.

What cursor type do you use to retrieve multiple recordsets?

Question Posted / pintu

Answer Posted / pintu

Is This Answer Correct ?

11 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Is left join faster than join?

1053

What is data abstraction in sql?

1031

Can we create view in stored procedure?

972

How do I run pl sql in sql developer?

1120

Explain the difference between sql and mysql.

1062

what is primary key? : Sql dba

1029

Does sql between include endpoints?

1015

What is the difference between instead of trigger and after trigger?

1010

How do you update sql?

981

What is scope and visibility in PL/SQL?

1204

Explain what is an index?

1056

What is a full join sql?

1056

What is basic structure of pl sql?

1071

What operators deal with null?

1107

Explain the methods used to protect source code of pl/sql.

1019