APPEND Procedure Signature 7

Appends an array of NUMBER to an array.

Syntax

MEMBER PROCEDURE append (
    p_value          IN   apex_t_number,
    p_spread         IN   BOOLEAN              DEFAULT FALSE,
    p_omit_empty     IN   BOOLEAN              DEFAULT TRUE );

Parameters

Parameter	Description
p_value	The array.
p_spread	Whether to append the values to the currently opened array as opposed to creating a new one.
p_omit_empty	Whether to omit the array if it is empty.

Example

Create an array that appends an array of type NUMBER.

declare
    l_obj apex_t_javascript_object  := apex_t_javascript_object();
    l_arr apex_t_number             := apex_t_number( 1, 2, 3 );
begin
    l_obj.open_array;
    l_obj.append( l_arr );
    l_obj.append (
        p_value     => l_arr,
        p_spread    => true );
    l_obj.close_array;

    sys.dbms_output.put_line( l_obj.to_clob );
end;

Output:
    [[1,2,3],1,2,3]