Re: Re[2]: Instead of SUM() I require MULTIPLY

Thanks all,
It's a very helpful solution. Have someone considered some similar occassion when we have to concat values?
For example,
1 a
1 b
3 c
4 a
1 e
then we want the resultset as
1 a,b,e
3 c
4 a

I have a solution in PL/SQL. Can a simple SQL solve it? Just curious :)

On 12/11/05, Ethan Post <post.ethan_at_gmail.com> wrote:
>
> Wow, great information everyone! Thanks for the more than helpful
> responses.
>
> On 12/10/05, Jonathan Gennick <jonathan_at_gennick.com> wrote:
> >
> >
> > Saturday, December 10, 2005, 7:40:51 AM,
> > Jonathan Gennick (jonathan_at_gennick.com ) wrote:
> > Friday, December 9, 2005, 10:21:22 PM, Mark Brinsmead (
> > mark.brinsmead_at_shaw.ca) wrote:
> >
>

--
Yao Yongping
Learning Oracle, UNIX/Linux...
Love Reading, Classical Music, Philosophy, Economics etc.
Blog: http://blog.csdn.net/ern
         http://spaces.msn.com/members/yaoyp/

--
http://www.freelists.org/webpage/oracle-l