http://alloracleapps.com/oracle/cursors-and-bulk-collect/

by using Cursor we fetch the data record by record and by using bulk Collect we get all the data at a time