How to return multiple records from procedure?
Answers were Sorted based on User's Feedback
Answer / hitendra yadav
We can return multiple records from procedure through
using reference cursor variable as out parameter of
procedure.
| Is This Answer Correct ? | 7 Yes | 3 No |
Answer / 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 |
What are the different types of a subquery?
what are the differences between char and varchar? : Sql dba
Can we join 3 tables in sql?
What is the difference between view and stored procedure?
Mention what does the hierarchical profiler does?
How many sql are there?
Why do we need pl sql?
How do you update a table in sql?
What are secondary keys?
What are inbuilt functions in sql?
What is case function?
Are views faster than queries?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)