Re: BULK UPDATE help

On Tue, 07 Aug 2007 18:49:54 -0000, wagen123_at_yahoo.com wrote:

>I know the update statement syntax:-)
>
>Looking for help with BULK UPDATE....
>
>
>thanks

You asked for the *most efficient* way to update those 3 columns to NULL. Using update *IS* the most efficient way!!!

Using BULK UPDATE you would need to perform a BULK COLLECT first in a collection. BULK COLLECT means FETCH.
Apart from that, isn't this a mere doc question? You can look up BULK UPDATE in the PL/SQL manual, can't you?

-- 




Sybrand Bakker
Senior Oracle DBA