RE: Instead of SUM() I require MULTIPLY

From: Lex de Haan <lex.de.haan_at_naturaljoin.nl>
Date: Sat, 10 Dec 2005 10:01:58 +0100
Message-ID: <001801c5fd68$60928b90$6501a8c0@LAPTOPLEX>

sorry -- if you follow the links from the URL I provided in the previous answer, you eventually end up in the OracleR Database Data Cartridge Developer's Guide  

and there, in chapter 11:
http://download-uk.oracle.com/docs/cd/B19306_01/appdev.102/b14289/dciaggfns.htm# sthref488  

you'll see complete coverage (including an example) of how to do it. but I guess you folks figured that out yourself already -- after all, the Oracle documentation is your biggest friend and best source of information -- right? :-)  

cheers,  

Lex.

---

Jonathan Lewis Seminar <http://www.naturaljoin.nl/events/seminars.html> http://www.naturaljoin.nl/events/seminars.html

---

 

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Ethan Post
Sent: Friday, December 09, 2005 23:13
To: oracle-l_at_freelists.org
Subject: Instead of SUM() I require MULTIPLY

I just came up with a function I would like, but don't think exists.  

TABLE TEST (X NUMBER)

---

2
2
4  

select sum(x) from test;  

will return 8...  

what I need is  

select multiply(x) from test;  

will return 16, because 2*2*4 is 16.  

Anyone ever seen a SQL aggregate function like this? I don't think it exists but I hold out hope.  

• Ethan

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

Received on Sat Dec 10 2005 - 03:02:02 CST