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(‘abc@test.com test@abc.com’));

Working from Apex 20.2