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 t (val varchar (4000))
insert into t values ('we rt qw')
1 rows affected

insert into t values ('qw er ty')
1 rows affected

insert into t values ('qw df gh')
1 rows affected

insert into t values ('we nk th')
1 rows affected

insert into t values ('wd hk uj')
1 rows affected

insert into t values ('wd hn of')
1 rows affected

insert into t values ('wd ol jj')
1 rows affected

select * from t where regexp_like(val,'.*hk.*| .*jj.*|.*we.*.')


VAL


we rt qw

we nk th

wd hk uj

wd ol jj