Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table TARGET_TABLE(name varchar2(30), surname varchar2(30));
insert into TARGET_TABLE(name,surname) values ('John', 'Doe');
1 rows affected

insert into TARGET_TABLE(name,surname) values ('Ann', 'Smith');
1 rows affected

insert into TARGET_TABLE(name,surname) values ('Steven', 'Feuerstein');
1 rows affected

insert into TARGET_TABLE(name,surname) values ('Steven', 'King');
1 rows affected

commit;
create table SOURCE_TABLE(filter) as
select q'[name='John']' from dual union all
select q'[name='Ann']' from dual union all
select q'[name='Steven' and surname='King']' from dual union all
select q'[surname='Feuerstein']' from dual;
4 rows affected

select *
from SOURCE_TABLE
    , xmltable(
        '/ROWSET/ROW'
        passing dbms_xmlgen.getXMLtype('select * from TARGET_TABLE where '|| SOURCE_TABLE.filter)
        columns 
          name    varchar2(30) path 'NAME',
          surname varchar2(30) path 'SURNAME'
        ) x


FILTER
NAME
SURNAME


name='John'
John
Doe

name='Ann'
Ann
Smith

name='Steven' and surname='King'
Steven
King

surname='Feuerstein'
Steven
Feuerstein

FILTER	NAME	SURNAME
name='John'	John	Doe
name='Ann'	Ann	Smith
name='Steven' and surname='King'	Steven	King
surname='Feuerstein'	Steven	Feuerstein