Answer Detail: RE: Retriving Multiple Records

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

Print |

Question: Retriving Multiple Records

Answer: Why PL/SQL does not support retriving multiple records?

November 11, 2008 17:57:25	#3
Mad Hatter	Member Since: November 2008 Total Comments: 5
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