bijulalgs

 Profile Answers by bijulalgs 

• Sep 30th, 2008

 

If you want to retriving multiple records you can use Reference Cursor

netrasurve

 Profile Answers by netrasurve 

• Oct 1st, 2008

 

In PL/SQL multiple records can be retrieved only through cursors.

Mad Hatter

 Profile Answers by Mad Hatter 

• Nov 4th, 2008

 

Multiple records at a time could be retreved in PL/SQL using BULK COLLECT.
To do that you define PL/SQL table, and load it using
SELECT ... BULK COLLECT INTO <pl/sql table>
FROM ..

Optionaly could be used LIMIT - to limit the number of records retreved at a time, like

SELECT ... BULK COLLECT INTO <pl/sql table>
FROM ..
LIMIT 1000

promisinganuj

 Profile Answers by promisinganuj 

• Sep 13th, 2009

 

Retriving multiple records is a basic feature of SQL where we fetch the data using SELECT statement.
SELECT *
  FROM emp;
This itself gives us multiple records. There is no additional feature required to do the same in PL/SQL.
At the same time, PL/SQL goes one step further and enable us to process these fetched rows one by one (unlike the update statements which updates all the rows selected).
There are several options for fethcing data in different PL/SQL constructs:
1. Using Ordinary Cursor
2. Using Ref Cursor
3. Using PL/SQL bulk collect
4. Using PL/SQL arrays

But the important thing here is that irrespective of the way we fetch the data, we act upon them row-by-row.