SELECT (a1 + a2)a,a1.rn
FROM (SELECT column_value a1,
rownum rn
FROM TABLE(split('1,2,3', ','))) a1,
(SELECT column_value a2,
rownum rn
FROM TABLE(split('11,22,33', ','))) a2
WHERE a1.rn = a2.rn