clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 2335834 fiddles created (27457 in the last week).

create table mytable(id integer, mycolumn char(1) default 'O');
 hidden batch(es)


insert into mytable(id) select level from dual connect by level<10;
9 rows affected
 hidden batch(es)


create global temporary table ids_to_update(id integer) on commit delete rows;
 hidden batch(es)


insert into ids_to_update(id) values(1);
1 rows affected
 hidden batch(es)


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


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


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


select * from mytable;
ID MYCOLUMN
1 X
2 X
3 X
4 O
5 O
6 O
7 O
8 O
9 O
 hidden batch(es)