db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mamatha Kodigehalli Venkatesh" <Mamatha.Venkat...@ness.com>
Subject Decode function as that in Oracle
Date Mon, 21 Feb 2011 11:56:00 GMT


Hello

Below query works in oracle.

Is there equivalent in Derby?

Update myTable set COL_1 = decode(COL_1,null,'Null', 'Mamatha') where key ='M9621'


Thanks
Mamatha

Mime
View raw message