55.28 SHUFFLE Function

Returns the input table values, re-ordered.

Syntax

APEX_STRING.SHUFFLE (
    p_table IN apex_t_varchar2 )
    RETURN apex_t_varchar2;

Parameters

Parameters Description
p_table The input table.

Example

Shuffle and print l_table.

declare
    l_table apex_t_varchar2 := apex_string.split('1234567890',null);
begin
    sys.dbms_output.put_line(apex_string.join(apex_string.shuffle(l_table),':'));
end;
-> a permutation of 1:2:3:4:5:6:7:8:9:0