Can you use a decode with the SET clause of UPDATE statement

Each,

Can you use a decode like so....

update table
set decode(field_a, value_1, field_b, field_c) = value_2;

Compiler says not....wanting to update either field_b or field_c depending on the value of field_a.

What say you?

TIA Roy Received on Mon Aug 02 2004 - 08:58:47 CDT