sys_connect_by_path用法（一个select语句中多条数据拼成一条数据）

创建表

create table demoTable(
    id number ,
    content varchar2(30)
);

测试数据

insert into demotable (ID, CONTENT)
values (1, 'content1');

insert into demotable (ID, CONTENT)
values (1, 'content2');

insert into demotable (ID, CONTENT)
values (2, 'content3');

insert into demotable (ID, CONTENT)
values (3, 'content4');

将多条数据的content字段拼成一个字符串

select max(sys_connect_by_path(content,' ')) from (
     select id,content ,rownum rn from demoTable 
)
start with rn=1
connect by prior rn=rn-1;

显示结果

[img]http://dl.iteye.com/upload/attachment/0072/3870/42c6ba96-fc26-3fa8-b839-0c847d1a288e.bmp[/img]