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 黃
,(case when instr(color,'黑') > 0 then 'Y' else ' ' end) as 黑
from Tmp


NUM
紅
黃
黑


A
Y
Y
 

B
 
 
Y

C
 
 
Y

D
Y
Y
Y