This function returns a list of generated inline rows from a semi colon (;) delimited list of values. For each value add a comma to define weight (such as F,45;M,30).

Syntax

APEX_DG_DATA_GEN.GET_WEIGHTED_INLINE_DATA (
    p_data  IN VARCHAR2 )
    RETURN wwv_flow_t_varchar2

Parameters

Example

The following example returns two rows: F and M.

select * 
from apex_dg_data_gen.get_weighted_inline_data( p_data => 'F;M');