user-defined group function

From: Raiden Fighter <raiden_fighter_at_my-deja.com>
Date: Sat, 11 Sep 1999 14:29:34 GMT
Message-ID: <7rdp05$78j$1@nnrp1.deja.com>

Is it possible to define a group function in PL/SQL and use that function in a SQL statement? I would like to do something like this:

SQL>desc table_a

Name        Not Null   Type
----        --------   ----
ID          N           NUMBER
NAME        N           VARCHAR2(10)

SQL>SELECT * FROM table_a
ID NAME
-- ----

1     Name1
1     Name2
1     Name3
2     A
2     B
3     F

SQL>SELECT id, my_group_func(name) "Concat" FROM table_a GROUP BY id ID Concat
-- -------
1 Name1 Name2 Name3
2 A B
3 F

3 rows selected

SQL>

Thanks!
Lynx

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Sat Sep 11 1999 - 09:29:34 CDT