这个SQL语句怎么实现

[yzf86211861]

SELECT LIST FROM PM_LAMINATOR_POSITION EF WHERE EF.LOTID = '1234'

结果是
1
4
5
6
....

我想要的结果是

1,4,5,6.... 以逗号隔开 连在一起在一列怎么写
在线等，来人教下我吧

[js14982]

SELECT WMSYS.WM_CONCAT(LIST) FROM PM_LAMINATOR_POSITION EF WHERE EF.LOTID = '1234';

[sourcecode1]

SELECT wm_concat( LIST) FROM PM_LAMINATOR_POSITION EF WHERE EF.LOTID = '1234'

[嘚嗒搬运工]

有这个试试，可以指定连接符

With temp(aa) As (
Select 1  From dual Union All
Select 4 From dual Union All
Select 5 From dual Union All
Select 6 From dual
)
Select listagg(aa,',') Within Group (Order By aa)  From temp;

[yzf86211861]

引用 3 楼 A_A_apan 的回复:

有这个试试，可以指定连接符

With temp(aa) As (
Select 1  From dual Union All
Select 4 From dual Union All
Select 5 From dual Union All
Select 6 From dual
)
Select listagg(aa,',') Within Group (Order By aa)  From temp;

Select 1 From dual Union All Select 4 From dual Union All Select 5 From dual Union All Select 6 From dual 这块我都不确定多少个 ，你这写法不实用.

[嘚嗒搬运工]

引用 4 楼 yzf86211861 的回复:

[quote=引用 3 楼 A_A_apan 的回复:] 有这个试试，可以指定连接符

With temp(aa) As (
Select 1  From dual Union All
Select 4 From dual Union All
Select 5 From dual Union All
Select 6 From dual
)
Select listagg(aa,',') Within Group (Order By aa)  From temp;

Select 1 From dual Union All Select 4 From dual Union All Select 5 From dual Union All Select 6 From dual 这块我都不确定多少个 ，你这写法不实用. [/quote] 也是醉了，这个跟你多少个没关系，你有多少个就拼接多少个。。。。。。。

SELECT  listagg(LIST,',') Within Group (Order By LIST) FROM PM_LAMINATOR_POSITION EF WHERE EF.LOTID =  '1234'

[yzf86211861]

引用 5 楼 A_A_apan 的回复:

[quote=引用 4 楼 yzf86211861 的回复:] [quote=引用 3 楼 A_A_apan 的回复:] 有这个试试，可以指定连接符

With temp(aa) As (
Select 1  From dual Union All
Select 4 From dual Union All
Select 5 From dual Union All
Select 6 From dual
)
Select listagg(aa,',') Within Group (Order By aa)  From temp;

Select 1 From dual Union All Select 4 From dual Union All Select 5 From dual Union All Select 6 From dual 这块我都不确定多少个 ，你这写法不实用. [/quote] 也是醉了，这个跟你多少个没关系，你有多少个就拼接多少个。。。。。。。

SELECT  listagg(LIST,',') Within Group (Order By LIST) FROM PM_LAMINATOR_POSITION EF WHERE EF.LOTID =  '1234'

[/quote] 作为一名新手这种动态 SQL 我不会写，怎么拼可以教下不？