select a,b from table(multiset{row(1,2)}) as t1(a,b) Union select a,decode(1,2,3) from table(multiset{row(1)}) as t1(a);