Oracle 21c

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

create table Tmp(
	Num VARCHAR2(10)
	,color VARCHAR2(50)
)
insert into Tmp(Num,color) values('A','紅黃、紅');
1 rows affected

insert into Tmp(Num,color) values('B','紅');
1 rows affected

insert into Tmp(Num,color) values('C','紅黃');
1 rows affected

insert into Tmp(Num,color) values('D','紅黃、紅');
1 rows affected

select Num
,(case when instr('、' || color || '、','、紅黃、') > 0 then 'Y' else ' ' end) as 紅黃
,(case when instr('、' || color || '、','、紅、') > 0 then 'Y' else ' ' end) as 紅
from Tmp


NUM
紅黃
紅


A
Y
Y

B
 
Y

C
Y
 

D
Y
Y