36.9 FIND_LINKS Function
This function finds https
and http
hypertext links
within text. The case of URL is preserved and the protocol is returned in lower
case.
Syntax
FUNCTION FIND_LINKS (
p_string IN VARCHAR2,
p_https_only IN BOOLEAN DEFAULT FALSE )
RETURN wwv_flow_t_varchar2;
Parameters
Table 36-9 FIND_LINKS Function Parameters
Parameter | Description |
---|---|
|
The input string. |
|
If true (the default is false), only returns
|
Returns
This function returns an array of links.
Example
declare
l_string varchar2(32767) := 'http://oracle.com i foo.com like https://carbuzz.com '||
'and <a href="https://dpreview.com"> and http://google.com';
l_results apex_t_varchar2;
begin
l_results := apex_string_util.find_links(l_string,false);
end;
/
-> apex_t_string (
'https://carbuzz.com',
'https://dpreview.com',
'http://oracle.com',
'http://google.com' )
Parent topic: APEX_STRING_UTIL