Home » SQL & PL/SQL » SQL & PL/SQL » Bulk collect or Cursor
Bulk collect or Cursor [message #358558] Tue, 11 November 2008 20:32 Go to next message
Messages: 5
Registered: November 2008
Junior Member
Hi Friends ,

Why should we use bulk collect rather than cursor ?
AS I know,In PL/SQL, using bulk collect, it is possible to select the values from mutliple rows in one go.

we can fetch data from cursor also .
Re: Bulk collect or Cursor [message #358563 is a reply to message #358558] Tue, 11 November 2008 20:50 Go to previous messageGo to next message
Messages: 3727
Registered: October 2005
Location: Melbourne, Australia
Senior Member
See this article for a reasonable coverage of the explanation.

Ross Leishman
Re: Bulk collect or Cursor [message #358636 is a reply to message #358558] Wed, 12 November 2008 00:51 Go to previous message
Michel Cadot
Messages: 65144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Also the documentation is there to help, so please refer to it first:
PL/SQL User's Guide and Reference
Application Developer's Guide - Fundamentals

Previous Topic: Encountered the symbol "end-of-file" when expecting one of the following
Next Topic: Truncate 1000 tables
Goto Forum:

Current Time: Sat Aug 19 11:57:15 CDT 2017

Total time taken to generate the page: 0.07013 seconds