Re: Own grouping function

In 9i there is a way to do this so the new aggregate function can be used directly in queries. You define an object type with standard methods, and these methods get called as needed to process each row.

http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a88896/dci11agg.htm#1004615

If you aren't using 9i, looking at this section might still help you determine the logic to use in doing it procedurally.

John

On Wed, 19 Dec 2001 09:20:03 +0100, "Sławomir Marcinkowski" <s.marcinkowski_at_Bankier.pl> wrote:

>Yes, I know that I need PL/SQL, but I don't know how to write the simplest
>agregate function like max, min or avg.
>Exist anywhere in network an example of function definition like that?
>
>Slawek
>
>
>
>Użytkownik "Ban Spam" <ban-spam_at_operamail.com> napisał w wiadomości
>news:Xns917BBB4F14E25SunnySD_at_24.0.3.73...
>> "Sławomir Marcinkowski" <s.marcinkowski_at_Bankier.pl> wrote in
>> news:9vn313$onc$1_at_news.tpi.pl:
>>
>> > I have to write my own grouping function like max or min. How can I do
>> > it? Slawek Marcinkowski
>> >
>> >
>> >
>>
>> PL/SQL or JAVA would be good choices.
>>
>>
>> HTH & YMMV
>>
>>
>> HAND!
>

--
Got an Oracle database question?
Try the search engine for the database docs at:
http://tahiti.oracle.com/