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: SQL question: GROUP BY: Is there a "SUM" for strings?

Re: SQL question: GROUP BY: Is there a "SUM" for strings?

From: <frank.van.bortel_at_gmail.com>
Date: 26 Apr 2006 02:33:02 -0700
Message-ID: <1146043982.717103.116170@u72g2000cwu.googlegroups.com>

Jerome Vitalis schreef:

> On Wed, 26 Apr 2006 09:01:20 +0200, Wolfram Roesler wrote:
>
> > Yes, thanks, but it won't work with GROUP BY, just like
> > '+' doesn't for numbers. Look at my example: What should
> > I write instead of SUM if colname was a VARCHAR2? As it
> > seems, however, there's no easy solution.
>
> Have a look there: http://tinyurl.com/plfmv

Now, looking at the answer, I finally understand the question :) Received on Wed Apr 26 2006 - 04:33:02 CDT

Original text of this message

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