Oracle 11g Release 2

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table snapshot_test (value number, error_code varchar2(10));
insert into snapshot_test(value) values (1);
1 rows affected

insert into snapshot_test(value) values (2);
1 rows affected

insert into snapshot_test(value) values (3);
1 rows affected

update snapshot_test
set error_code = 
  ltrim(
    case when (value = 1) then ',8' end
    || case when (mod(value, 2) = 1) then ',9' end
    || case when (value > 1) then ',10' end
    , ',');
3 rows affected

select * from snapshot_test;


VALUE
ERROR_CODE


1
8,9

2
10

3
9,10


drop table snapshot_test purge;