Oracle 11g Release 2

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

CREATE TABLE customer
    ("id" int, "name" varchar2(5), "address" varchar2(14), "state" varchar2(2))
;
INSERT ALL 
    INTO customer ("id", "name", "address", "state")
         VALUES (1, 'John', '123 main st', 'TX')
    INTO customer ("id", "name", "address", "state")
         VALUES (2, 'Jack', '678 John st', 'NJ')
    INTO customer ("id", "name", "address", "state")
         VALUES (3, 'Bet', '987 Tx st', 'NY')
    INTO customer ("id", "name", "address", "state")
         VALUES (4, 'Maddy', '9812 Hudson st', 'CA')
    INTO customer ("id", "name", "address", "state")
         VALUES (5, 'ABCD', '9813 Mainly st', 'PA')
SELECT * FROM dual
;
5 rows affected

UPDATE customer
SET "state" = 'CA'
WHERE ',' || '1,2,3' || ',' LIKE '%,' || "id" || ',%'
3 rows affected

SELECT * FROM customer


id
name
address
state


1
John
123 main st
CA

2
Jack
678 John st
CA

3
Bet
987 Tx st
CA

4
Maddy
9812 Hudson st
CA

5
ABCD
9813 Mainly st
PA

id	name	address	state
1	John	123 main st	CA
2	Jack	678 John st	CA
3	Bet	987 Tx st	CA
4	Maddy	9812 Hudson st	CA
5	ABCD	9813 Mainly st	PA