25.14 PUSH Procedure Signature 3

This procedure appends collection values to apex_t_varchar2 table.

Syntax

push (
   p_table  in out nocopy apex_t_varchar2,
   p_values in            apex_t_varchar2 );

Parameters

Table 25-16 PUSH Procedure Signature 3 Parameters

Parameter Description

p_table

Defines the table.

p_values

Specifies the values that should be added to p_table.

Example

The following example demonstrates how to append 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_varchar2('1','2','3'));    
   sys.dbms_output.put_line(apex_string.join(l_table, ':'));
end;
-> a:1:2:3