Re: Using Cursors

galenboyerdev_at_hotpop.com
Date: 01/25/05


Date: Tue, 25 Jan 2005 08:49:50 -0500


"--CELKO--" <jcelko212@earthlink.net> writes:

>>> Cursors are no more an Oracle habit than they are a SQL Server
> habit. They
> are just as necessary/unnecessary in Oracle as they are in SQL Server.
> <<
>
> I have to agree with Dave on that one. Looking at Oracle code at
> client sites, I find that it is usually full of cursors.

I find that programmers turned database coders are the ones that
perpetuate this problem. And, yes, its a problem. A serious problem.
Set logic should be used until it cannot solve the issue. And, even
when it can't, I'd start getting a bit suspicious of the database
design. But, they do have their place.

-- 
Galen Boyer