FIND_EMAIL_ADDRESSES Function

43.2 FIND_EMAIL_ADDRESSES Function

This function finds all email addresses in the given input string.

Syntax

FUNCTION FIND_EMAIL_ADDRESSES (
    p_string IN VARCHAR2 )
    RETURN apex_t_varchar2;

Parameters

Table 43-2 FIND_EMAIL_ADDRESSES Function Parameters

Parameter	Description
`p_string`	The input string.

Returns

This function returns an array of email addresses without duplicates.

Example

declare
    l_string  varchar2(32767) := 'b@c.it hello this hello.world@example.com is text b@c.it includes the '||
                                 'michael.h@example.com email address and x.y.z@m.io';
    l_results apex_t_varchar2;
begin
    l_results := apex_string_util.find_email_addresses(l_string);
end;
/
-> apex_t_varchar2 (
       'b@c.it',
       'hello.world@example.com',
       'michael.h@example.com',
       'x.y.z@m.io' )

Parent topic: APEX_STRING_UTIL