Re: Gnarley Query - can this be done in oracle ?

Yes it can be done using the decode function (I created a table called test using your specs):

update test
set fred=decode(wilma,'red',3,fred) ,

    barney=decode (fred,7,'true',barney) / Received on Fri Aug 16 1996 - 00:00:00 CEST