Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> How to write a single-group group function
I need help writing a single-group group function. This function
needs to concat the content of a field for all rows for a given
group. For example:
Table test
X Y - - 1 A 2 A 4 C 3 D
I want to use a select statement like:
select min(x),max(x),count(x),my_function(y);
and return:
min(x) max(x) count(x) my_function(y)
1 4 4 AACD
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Oct 15 1999 - 08:58:37 CDT