SELECT  DATA
,       POS
,       substr(DATA, POS, 1) DD
FROM    (
        SELECT  DATA
        ,       LEVEL#  POS
        FROM    (
                SELECT  replace('A|B|C|D', '|', '') AS DATA
                ,       LEVEL#
                FROM    DUAL
                ,       (
                        SELECT  LEVEL LEVEL#
                        FROM    DUAL
                        CONNECT BY LEVEL < 5
                        )   L
                WHERE   1=1
                )   T
        START   WITH LEVEL# = 1
        CONNECT BY  PRIOR LEVEL# = LEVEL# -1
        AND         PRIOR DATA   = DATA
        )   Z
;