SELECT parvan1 FROM (
SELECT SUBSTR(parvac1, position_from + 1, position_to - position_from - 1) i, parvan1
FROM (SELECT parvac1, parvan1,
DECODE(ROWNUM - 1, 0, 0, INSTR(parvac1, ',', 1, ROWNUM - 1)) position_from,
INSTR(parvac1, ',', 1, ROWNUM) position_to
FROM (
SELECT parvac1||',' parvac1, parvan1 FROM parpostes
WHERE partabl = 7010
AND parcmag = 10
AND parvan2 = 1
AND parvac1 IS NOT NULL
)
CONNECT BY LEVEL <= LENGTH(parvac1))
WHERE position_to > 0
) pp, fouattri WHERE fatcfin = '3473' AND FATCLA = 'AORD' AND SYSDATE BETWEEN fatddeb AND fatdfin
AND fatatt=i