Oracle 11g Release 2

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

create table mytable(id integer, mycolumn char(1) default 'O');
insert into mytable(id) select level from dual connect by level<10;
9 rows affected

create global temporary table ids_to_update(id integer) on commit delete rows;
insert into ids_to_update(id) values(1);
1 rows affected

insert into ids_to_update(id) values(2);
1 rows affected

insert into ids_to_update(id) values(3);
1 rows affected

update mytable set mycolumn='X' where id in(select id from ids_to_update);
3 rows affected

select * from mytable;


ID
MYCOLUMN


1
X

2
X

3
X

4
O

5
O

6
O

7
O

8
O

9
O