Re: User defined aggregate function

From: Adrian Billington <billiauk_at_yahoo.co.uk>
Date: 30 Nov 2004 05:24:49 -0800
Message-ID: <dee17a9f.0411300524.3a511832@posting.google.com>

Patrick,

10g has a COLLECT function, which can be combined with a TO_STRING function to outperform STRAGG quite considerably. Take a look at an example I posted on asktom re: the very same:-

http://asktom.oracle.com/pls/ask/f?p=4950:61:17512898405899953896::::P61_ID:2196161600402#18313422264397

Regards
Adrian Received on Tue Nov 30 2004 - 07:24:49 CST

This message: [ Message body ]
Next message: sybrandb_at_yahoo.com: "Re: How get the current value from a sequence?"
Previous message: Hans: "Update nls_length_semantics!"
In reply to: Patrick Mézard: "User defined aggregate function"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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