PUSH Procedure Signature 7

55.27 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 apex_t_varchar2,
    p_values        IN            apex_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

Parent topic: APEX_STRING