Re: CONCAT group operator

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/12/03
Message-ID: <662vng$kl4@mtinsc02.worldnet.att.net>#1/1

One (clumsy) way to do what you want:

SELECT CONCAT(a.t, b.t)
FROM x a, x b
WHERE a.t <> b.t
AND a.t = 'First';

Hope this helps.

Michael Serbanescu

---

On Tue, 2 Dec 1997 17:19:47 GMT, Mike Gahan <ccaamrg_at_ucl.ac.uk> 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/
>
Received on Wed Dec 03 1997 - 00:00:00 CST