FROM HSDATA4.DWRECAP (SELECT DW.DWINVNFROM HSDATA4.DWRECAP DW
INNER JOIN HSDATA4.FXVNDCP FX ON DW.DWVNDN = FX.FXVNDNWHERE DW.DWRTPE = 1 AND DW.DWDTEI BETWEEN 20180904 AN
我在RPD中引入了一个字段OBIEE,并使用它们的EVALUATE_AGGR函数创建了一个逗号分隔的列表。我使用的是Oracle管理工具v11.1.1.7.1。EVALUATE_AGGR('LISTAGG(%1) WITHIN GROUP (ORDER BY %1)' AS CHAR,"DW".""."DW"."