假设你的表结构是tb_name(id, re),则语句如下: SELECT a.id, wm_concat (a.re) new_result FROM tb_name a group by a.id 不过我不知道9i支不支持这个
sys_connect_by_pat函数,参考这个 select max(substr(sys_connect_by_path(column_name,','),2)) from (select column_name,rownum rn from user_tab_columns where table_name ='DEPT') start with rn=1 connect by rn=rownum ;
SELECT
a.id,
wm_concat (a.re) new_result
FROM
tb_name a
group by
a.id
不过我不知道9i支不支持这个
select max(substr(sys_connect_by_path(column_name,','),2))
from (select column_name,rownum rn from user_tab_columns where table_name ='DEPT')
start with rn=1 connect by rn=rownum ;