You have to return the selected cursor as OUT parameter and again you hav

How to return multiple records from procedure?

Question Posted / swapna

Answer Posted / swapna

You have to return the selected cursor as OUT parameter and
again you have to fetch the data from that OUT cursor.

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are pl sql procedures?

1014

what is myisam? : Sql dba

1055

How to add a column ‘salary’ to a table employee_details?

994

Can we update views in sql?

925

Explain exception handling in pl/sql?

1021

Write an sql query to select all records from the table?

1000

How to change the order of columns in Oracle SQL Plus ?

1041

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1199

How can we optimize a sql query?

1030

What is latest version of sql?

1028

How do you remove duplicates without using distinct in sql?

962

Are subqueries better than joins?

957

Which is faster count (*) or count 1?

1009

Can we have two clustered index on a table?

1011

what are all the different normalizations? : Sql dba

1015