select decode(rownum, 1, a.val, 2, b.val, 3, c.val) from (select 'A' as val from dual) a , (select 'B' as val from dual) b , (select 'C' as val from dual) c , (select rownum from dual connect by rownum