Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Writing aggregate functions

Re: Writing aggregate functions

From: Ralf Jonas <ralf.jonas_at_gmx.de>
Date: Tue, 05 Mar 2002 10:33:05 +0100
Message-ID: <a623el$b45ve$1@ID-6634.news.dfncis.de>


Hi Paul,

Paul Quenneville wrote:
>
> concat ?
>
> "Ralf Jonas" <ralf.jonas_at_gmx.de> wrote in message
> news:a6014u$aj7fn$1_at_ID-6634.news.dfncis.de...
> > Hi there,
> >
> > is there any chance to write an aggregate function?? I need a function
> > like 'sum' which doesn't sums up numbers but strings into a CLOB field.
> > I know, there are 50 ways doing this by external loops and around 50 of
> > them are not usable for me.
> >
> > Ralf, waiting for someone who doesn't want to tell me the 51th way.

so you really want to tell me, your oracle accepts statements like this?

select concat(textfield) from data_table_14;

Hey, thats great. Where can I get your Oracle version??

Ralf Received on Tue Mar 05 2002 - 03:33:05 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US