Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Cursor in PL/SQL

Cursor in PL/SQL

From: Troiano, Paul (CAP, GEFA) <Paul.Troiano_at_gecapital.com>
Date: Mon, 22 May 2000 17:49:02 -0400
Message-Id: <10505.106285@fatcity.com>


I am writing a PLS/SQL procedure that needs to deal with a table with 100 columns. All 100 columns are needed and there can be anywhere from 5 to 10,000 records to be dealt with at a time. Is it better to create a cursor with all 100 fields and then deal with them? Or, is it better to create the cursor with just the primary key and use a SELECT ... INTO, for all 100 fields, as needed?

Why?

Thanks, Received on Mon May 22 2000 - 16:49:02 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US