创建表
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;