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

What is the use of partition by in sql?

514

What are the possible values for the boolean data field?

518

What is a call statement? Explain with an example.

545

what is the difference between rownum pseudo column and row_number() function? : Sql dba

616

what are the types of join and explain each? : Sql dba

530

What is primary key secondary key alternate key candidate key?

541

How do I save the results of sql query in a file?

533

How to display Row Number with Records in Oracle SQL Plus?

590

What is the difference between delete and truncate statement in sql?

493

What is serial sql?

522

What found sql?

520

what are all the different normalizations? : Sql dba

505

define sql delete statement ? : Sql dba

556

How to pipe multiline string to isql?

574

What is raid? How does it help storage of databases?

599