表a,一个字段dhhm,数据如下:SQL> select * from wjj;DHHM
--------------------
13812344444
13310000444
33310000444
55510000444求一个sql语句,得到结果如下:
13812344444,13310000444,33310000444,55510000444
--------------------
13812344444
13310000444
33310000444
55510000444求一个sql语句,得到结果如下:
13812344444,13310000444,33310000444,55510000444
SQL> select wm_concat(dhhm) from wjj;select wm_concat(dhhm) from wjjORA-00904: "WM_CONCAT": 无效的标识符
select Max(ltrim(sys_connect_by_path(dhhm,','),',')) FROM
(
SELECT dhhm,ROWNUM rn from wjj
)
START WITH rn=1
CONNECT BY PRIOR rn=rn-1 ;