Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
select * from V$VERSION;


BANNER
BANNER_FULL
BANNER_LEGACY
CON_ID


Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
Version 18.4.0.0.0
Oracle Database 18c Express Edition Release 18.0.0.0.0 - Production
0


create table two (dat varchar (4000), tst varchar (4000), df varchar(20))
INSERT into two (dat, tst, df) values ('1234', 'ss tr rt', 'vol1')
1 rows affected

INSERT into two (dat, tst, df) values ('1235', 'ab rt', 'vol2')
1 rows affected

INSERT into two (dat, tst, df) values ('1238', 'er ty ui', 'vol3')
1 rows affected

select * from two


DAT
TST
DF


1234
ss tr rt
vol1

1235
ab rt
vol2

1238
er ty ui
vol3


with params (par1, par2) as (
    select sys.ODCIVarchar2List('vol1','vol2'), 'vol3' from dual 
)
select two.* from two, params
where df in (
    select column_value from table (par1) union all
    select par2  from dual
    )


DAT
TST
DF


1234
ss tr rt
vol1

1235
ab rt
vol2

1238
er ty ui
vol3