19.14 GET_WEIGHTED_INLINE_DATA Function

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

Table 19-14 GET_WEIGHTED_INLINE_DATA Parameters

Parameter	Description
p_data	The list of values.

Example

The following example returns two rows: F and M.

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