Hi,
I would like to change some rows in a table to two different values
depending on the current value.
The value of the column "status" should be changed to ''CLOSED_SUCC''
when its current value is ''OPEN_SUCC'' and it should be ''CLOSED_FAIL''
when the current value is ''OPEN_FAIL''. Of course I could write two
statements, but can it be done in one statement ?
I tried to do it with "case" but that failed.
update lr_object_usage set status = (case when status = ''OPEN_SUCC''
then ''CLOSED_SUCC'' when status = ''OPEN_FAIL'' then ''CLOSED_FAIL'');