oracle 多个日期字符串取最大 function

create or replace function compare_dates(v_string varchar2) return varchar2 is
  v_result varchar2(30);

begin
   select max(dates) into v_result from (
   SELECT REGEXP_SUBSTR (v_string, '[^,]+', 1,rownum) dates

   from dual connect by rownum<=LENGTH (v_string) - LENGTH (regexp_replace(v_string, ',', ''))+1);

   return v_result;

end compare_dates;



select compare_dates('2023/04/08,2022/09/12') from dual;