54.25 PUSH Procedure Signature 7

This procedure appends number collection values to the apex_t_varchar2 table.

Syntax

APEX_STRING.PUSH (
    p_table         IN OUT NOCOPY wwv_flow_t_varchar2,
    p_values        IN            wwv_flow_t_number,
    p_format_mask   IN            VARCHAR2 DEFAULT NULL );

Parameters

Parameter	Description
p_table	The table.
p_values	Values that should be added to p_table.
p_format_mask	Format mask to use when converting numbers to strings.

Example

The following example appends a single value and multiple values, then prints the table.

DECLARE
    l_table apex_t_varchar2;
BEGIN
    apex_string.push(l_table, 'a');
    apex_string.push(l_table, apex_t_number(1,2,3), 'FM990D00');
    sys.dbms_output.put_line(apex_string.join(l_table, ':'));
END;
-> a:1.00:2.00:3.00