Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Simple question ...
Ernest Morariu wrote:
> Michel,
>
> Many thanks for the links. I've already put them in my "Favorites".
>
> I knew I can use cursors for getting the same result(without relying on
> exceptions).
> The "SELECT INTO myVar" seemd to me more nice, but
> now I know that I shoud use it just when it works without generating
> exceptions in 99,9% of cases.
>
>
> ernest
I think you have drawn an incorrect conclusion. Cursors are alway slower than the alternative DML statement you had originally.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Fri Aug 06 2004 - 17:59:31 CDT