| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> c.d.o.misc -> CONCAT group operator
Is there any such thing as a CONCAT group operator?
What I mean is something like the SUM operator, which totals numbers over selected rows. This one would concatenate character fields over selected rows:
create table x (t varchar2(20));
insert into x values ('First');
insert into x values ('Second');
select concat(t) from x;
CONCAT(T)
FirstSecond
1 Row Selected
Or something like.
It seems such an obvious function, but I have scoured the documentation in vain for some reference.
--
Mike Gahan
Information Systems Division
University College London
http://www.ucl.ac.uk/~ccaamrg/
Received on Tue Dec 02 1997 - 00:00:00 CST
![]() |
![]() |