25.3 GREP Function Signature 1

Returns the values of the input table that match a regular expression.

Syntax

grep (
   p_table         in wwv_flow_t_varchar2,
   p_pattern       in varchar2,
   p_modifier      in varchar2    default null,
   p_subexpression in varchar2    default '0',
   p_limit         in pls_integer default null )
   return wwv_flow_t_varchar2;

Parameters

Table 25-3 GREP Function Signature 1 Parameters

Parameters Description

p_table

The input table.

p_pattern

The regular expression.

p_modifier

The regular expression modifier.

p_subexpression

The subexpression which should be returned. If null, return the complete table value. If 0 (the default), return the matched expression. If > 0, return the subexpression value. You can also pass a comma separated list of numbers, to get multiple subexpressions in the result.

p_limit

Limitation for the number of elements in the return table. If null (the default), there is no limit.

Example

Collect and print basenames of sql files in input collection.

declare
    l_sqlfiles apex_t_varchar2;
begin
    l_sqlfiles := apex_string.grep (
                       p_table => apex_t_varchar2('a.html','b.sql', 'C.SQL'),
                       p_pattern => '(\w+)\.sql',
                       p_modifier => 'i',
                       p_subexpression => '1' );
    sys.dbms_output.put_line(apex_string.join(l_sqlfiles, ':'));
end;
-> b:C