Fwd: Question on update ... where current of ...

From: Richard Ji <richard.c.ji_at_gmail.com>
Date: Thu, 17 Mar 2005 23:35:47 -0500
Message-ID: <b4d52f205031720354d9d4d0c@mail.gmail.com>

This where you should just do it in SQL with a single update statement, not PL/SQL.

On Thu, 17 Mar 2005 23:29:09 -0500, Guang Mei <GMei_at_ph.com> wrote:
> Hi,
>
> A quick pl/sql question for oracle 9i. I have these two pl/sql blocks below,
> does oracle treat them same internally when inside the loop?
>
> Would "method 2" be better, in terms of performance?
>
> Thanks.

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Mar 17 2005 - 23:39:17 CST