Re: is concat a group by function?

In article <%zFI6.1690$vg1.141759_at_www.newsranger.com>, Aloha Kakuikanu says...
>
>SELECT
>MGR,
>CONCAT( EMPNO ) || ','
>FROM SCOTT.EMP
>group by MGR
>
>doesn't work, of course. Any other way to do it?
>

Here is a way to group by into a collection in oracle

SELECT
MGR,
CAST(MULTISET(SELECT empno
FROM EMP e
WHERE e.mgr=m.MGR
)
AS number_list_t) ENO
FROM EMP m
group by MGR

(what a syntax!)
They'll have user defined aggregates in 9i. Received on Sat May 05 2001 - 02:21:17 CEST