39.8 FIND_TAGS Function

This function finds all strings prefixed with a tag identifier. The search is case insensitive and also ignores white space and special characters.

Syntax

FUNCTION FIND_TAGS (
    p_string          IN VARCHAR2,
    p_prefix          IN VARCHAR2 DEFAULT '#',
    p_exclude_numeric IN BOOLEAN  DEFAULT TRUE )
RETURN wwv_flow_t_varchar2;

Parameters

Table 39-8 FIND_TAGS Function Parameters

Parameter	Description
p_string	The input string.
p_prefix	The tag prefix (default '#').
p_exclude_numeric	If true (the default), excludes values that only consist of the tag identifier and digits.

Returns

This function returns the found tags in upper case.

Example

declare
    l_tags   apex_t_varchar2;
    l_string varchar2(4000) := 'how now #orclapex @mike brown #cow';
begin
    l_tags := apex_string_util.find_tags(l_string,'#');
    l_tags := apex_string_util.find_tags(l_string,'@');
end;
/
-> apex_t_varchar2('#ORCLAPEX','#COW')
-> apex_t_varchar2('@MIKE')