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
deep_kol
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
rleishman
Messages: 3724
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: 64109
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

Regards
Michel
Previous Topic: create database
Next Topic: Truncate 1000 tables
Goto Forum:
  


Current Time: Mon Dec 05 06:42:13 CST 2016

Total time taken to generate the page: 0.06142 seconds