How to multiple value search in Oracle Database field

create table t1 

(

data varchar2(20)

)

/

insert into t1 values('GTY')

/

insert into t1 values('GAT')

/

insert into t1 values('GRP')

/

select *

from t1

where data in

(

select

regexp_substr('&p_company','[^;]+', 1, level)

from dual

connect by regexp_substr('&p_company', '[^;]+', 1, level)

is not null)