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 ('Other', '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


Other
ss tr rt
vol1

1235
ab rt
vol2

1238
er ty ui
vol3


select * from two
where df in (decode(dat, 'Other', 'vol1'), 'vol2')


DAT
TST
DF


Other
ss tr rt
vol1

1235
ab rt
vol2