SQL如何从内部的双重列表中创建列表

Question

我不想创建TMP表。如何使这项工作？

with a as (
340401182,
340401183
)
select * from a

Answer 1

如果您想要两行，一列执行此操作

with a as 
(
   Select 340401182 as val from dual
   UNION ALL
   Select 340401183 as val from dual
)
select * from a

Answer 2

非常接近....

with a as (
SELECT 
    340401182 AS Col1,
    340401183 as Col2
)
select * from a