例如记录 id col1 ---- ----- 1 aa 1 bb 1 cc 2 dd 2 ff 想输出结果 id sum_c ---- ------ 1 aabbcc 2 ddff 怎么写语句呢
sql语句做不到 写个存储过程或者函数
create function get_value(p_id in varchar2) return varchar2 as str varchar2(50); cursor t_sor is select col1 from table_name where id=p_id; begin for v_sor in t_sor loop str:=str||v_sor.col1; end loop return str; end; / select id,get_value(id) from table_name group by id;
id col1
---- -----
1 aa
1 bb
1 cc
2 dd
2 ff
想输出结果
id sum_c
---- ------
1 aabbcc
2 ddff
怎么写语句呢
写个存储过程或者函数
return varchar2
as
str varchar2(50);
cursor t_sor is
select col1 from table_name where id=p_id;
begin
for v_sor in t_sor loop
str:=str||v_sor.col1;
end loop
return str;
end;
/
select id,get_value(id) from table_name group by id;