Oracle Database Discussions

Hi,

I need to update multiple columns of the same table with a fixed value only when the column value is not null.

UPDATE   MYTAB

      SET COL1 = DECODE(COL1, NULL,NULL, 'MYFIXEDVALUE1'),

              COL2 = DECODE(COL2, NULL,NULL, 'MYFIXEDVALUE2'),

              COL3 = DECODE(COL3, NULL,NULL, 'MYFIXEDVALUE3');

have you some other method?

Database; 11.2

thank you