Extracting email addresses from the text was never this easy in #orclapex.. What do you say? Also, check out other useful functions FIND_LINKS, FIND_TAGS in APEX_STRING_UTIL package

select * from table(apex_string_util.find_email_addresses(‘[email protected] [email protected]’));

Working from Apex 20.2