36.5 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 wwv_flow_t_varchar2;
Parameters
Table 36-5 FIND_EMAIL_ADDRESSES Function Parameters
Parameter | Description |
---|---|
|
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