PL/SQL - Retriving Multiple Records

GeekInterview.com > Interview Questions > Oracle > PL/SQL

Go To First | Previous Question | Next Question

PL/SQL | Question 232 of 237

Retriving Multiple Records

Why PL/SQL does not support retriving multiple records?

Total Answers and Comments: 3

Last Update: November 04, 2008 Asked by: bmsrao

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 30, 2008 02:53:35

bijulalgs

Member Since: September 2008 Contribution: 1

RE: Retriving Multiple Records

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

Is this answer useful? Yes | No

October 01, 2008 07:05:04

netrasurve

Member Since: January 2008 Contribution: 2

RE: Retriving Multiple Records

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

Is this answer useful? Yes | No

November 04, 2008 17:57:25

Mad Hatter

Member Since: November 2008 Contribution: 6

RE: Retriving Multiple Records

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

Is this answer useful? Yes | No

Go To Top