BULK UPDATE help

Hi,

Oracle10g 10.2.0.1
RHEL AS 4.4 I need to update three columns to a NULL value (most efficient way). Can't drop table. Can anyone help me with BULK UPDATE. Table has 2 million rows

SQL> desc t1

c1     NUMBER;
c2     VARCHAR2(255)
c3     VARCHAR2(255)
c4     VARCHAR2(30)

Need to update c2,c3,c4 to NULL using BULK UPDATE.

Any help/pointers.

Thanks
wagen Received on Tue Aug 07 2007 - 13:42:02 CDT