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

Home -> Community -> Usenet -> c.d.o.server -> Re: Simple question ...

Re: Simple question ...

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 06 Aug 2004 15:59:31 -0700
Message-ID: <1091833209.462737@yasure>


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

Original text of this message

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