33.3 GET_SEARCHABLE_PHRASES Function
This function returns distinct phrases of 1-3 consecutive lower case words in the input strings. Stopwords in the given language are ignored and split phrases.
Note:
This is a PL/SQL only implementation of a very small subset of what Oracle Text provides. Consider using Oracle Text instead, if the features and performance of this function are not sufficient.Syntax
function get_searchable_phrases (
p_strings in wwv_flow_t_varchar2,
p_max_words in pls_integer default 3,
p_language in varchar2 default 'en' )
return wwv_flow_t_varchar2;
end wwv_flow_string;
/
Parameters
Table 33-3 GET_SEARCHABLE_PHRASES Function Parameters
Parameters | Description |
---|---|
|
The input string. |
|
The maximum number of words in a phrase. The default is 3. |
|
The language identifier for stopwords, defaults to |
Example
Prints keywords in the given input string.
begin
sys.dbms_output.put_line (
apex_string.join (
apex_string.get_searchable_phrases (
p_strings => apex_t_varchar2 (
'Oracle APEX 19.1 is great.',
'Low code as it should be!' )),
':' ));
end;
-> oracle:oracle apex:oracle apex 19.1:apex:apex 19.1:19.1:great:low:low code:code
Parent topic: APEX_STRING