Re: CONCAT group operator

From: Matthias Gresz <GreMa_at_t-online.de>
Date: 1997/12/03
Message-ID: <6630av$13r$1@news00.btx.dtag.de>#1/1

Mike Gahan wrote:
>
> 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/

Hi Mike,

do you mean

YourTable:

First Second

---

Item1 Item2

Select First || Second Concat from yourTable;

Concat

---

Item1Item2
?

-- 
Regards

Matthias Gresz    :-)

Received on Wed Dec 03 1997 - 00:00:00 CST