Re: BULK UPDATE help

<wagen123_at_yahoo.com> a écrit dans le message de news: 1186512122.652804.144420_at_k79g2000hse.googlegroups.com...
| 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
|

update t1 set c2=null, c3=null, c4=null;

Regards
Michel Cadot Received on Tue Aug 07 2007 - 13:44:36 CDT