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 or replace type split_tbl as table of varchar2(128);
/
create or replace function split(
  list in CHAR,
  delimiter in CHAR default ','
) 

return split_tbl as
  splitted split_tbl := split_tbl();
  i pls_integer := 0;
  list_ varchar2(32767) := list;

begin
  loop
    i := instr(list_, delimiter);
    if i > 0 then
      splitted.extend(1);
      splitted(splitted.last) := substr(list_, 1, i - 1);
      list_ := substr(list_, i + length(delimiter));
    else
      splitted.extend(1);
      splitted(splitted.last) := list_;
      return splitted;
    end if;
  end loop;
end;
/
create table user_salaries (
  id number generated always as identity primary key
  , name varchar2(24)
  , salary number
  , salary_date date)
/  
insert into user_salaries (name, salary, salary_date)
with emps (name, sal) as (
select 'FOX IN SOCKS', 10000 from dual union all
select 'MR KNOX', 8500 from dual union all
select 'THING ONE', 1770 from dual union all
select 'THING TWO', 1771 from dual union all
select 'SAM-I-AM', 11100 from dual union all
select 'DAISY-HEAD MAYZIE', 12000 from dual 
)
select name, sal + (10*level), add_months(date '2019-01-01', level - 1) 
from emps
connect by level <= 10 and emps.name = prior emps.name and prior sys_guid() is not null 
/
60 rows affected

select us.name
       , us.salary
from table(split('FOX IN SOCKS,THING ONE,THING TWO')) t       
     cross apply (select us.name, max(us.salary) as salary 
                  from user_salaries us
                  where us.name = t.column_value ) us
/                  


NAME
SALARY


FOX IN SOCKS
10100

THING ONE
1870

THING TWO
1871