sql高手请进来，请问如何将查询的一列数据拼接用逗号隔开显示成一条记录?

[huaiyan]

请问如何将查询的一列数据拼接用逗号隔开显示成一条记录?

[huaiyan]

CREATEDTIME
--------------
1322049461
1322041123
1322049461
显示为 1322049461,1322041123 ,1322049461

[cosio]

SELECT b FROM 
(
  SELECT substr(a,LEVEL,1) b FROM 
  (
         SELECT '1,2,3,4'||',' a FROM dual
  ) CONNECT BY LEVEL<length(a)
)WHERE b<>','

--result:
1
2
3
4

[cosio]

WITH t AS
(
SELECT 1322049461 a FROM dual
UNION ALL
SELECT  1322041123    FROM dual
UNION ALL
SELECT  1322049461 FROM dual
)
--9i
SELECT max(substr(sys_connect_by_path(a,','),2)) b
FROM 
       (SELECT a,row_number() over(ORDER by a) rn FROM t)
 START WITH rn=1 CONNECT BY rn-1=PRIOR rn

--10g
select wm_concat(a,',') from t

[huaiyan]

我想要的结果是最后返回一行数据，数据的内容的这一列的数据用逗号隔开显示！
[Quote=引用 2 楼 cosio 的回复:]

SQL code
SELECT b FROM
(
SELECT substr(a,LEVEL,1) b FROM
(
SELECT '1,2,3,4'||',' a FROM dual
) CONNECT BY LEVEL<length(a)
)WHERE b<>','

--result:
1
2
3
4
[/Quote]

[programmerxiaocai]

oracle 10g 就简单了 用Wm_concat()函数。

[huaiyan]

--9i 这个可以用 ， 谢谢啦！
[Quote=引用 3 楼 cosio 的回复:]

SQL code

WITH t AS
(
SELECT 1322049461 a FROM dual
UNION ALL
SELECT 1322041123 FROM dual
UNION ALL
SELECT 1322049461 FROM dual
)
--9i
SELECT max(substr(sys_connect_by_path(a,','),2)) b
FROM
……
[/Quote]

[huaiyan]

大侠呀！ 神人也！
[Quote=引用 3 楼 cosio 的回复:]

SQL code

WITH t AS
(
SELECT 1322049461 a FROM dual
UNION ALL
SELECT 1322041123 FROM dual
UNION ALL
SELECT 1322049461 FROM dual
)
--9i
SELECT max(substr(sys_connect_by_path(a,','),2)) b
FROM
……
[/Quote]