Re: Cursor in PL/SQL

"Troiano, Paul (CAP, GEFA)" wrote:
>
> 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?

Use the cursor to all fields. Oracle would open an implicit cursor anyway, so you aren't adding any additional processing. The SELECT INTO method is just more SQL to parse and execute, and doesn't offer any additional functionality.

Cheers,

g

-- 
guy ruth hammond <grh_at_agency.com> | Happiness is a loaded weapon, and
Technology Analysis & Consulting  |   a short cut is better by far.
07879607148 http://www.agency.com |     -- The Sisters of Mercy