Re: OT: array_accum equivalent in Oracle - Mailing list pgsql-sql

On 10/12/07, Andreas Joseph Krogh <andreak@officenet.no> wrote:
> Anybody knows if Oracle has an equivalent of PG's array_accum or
> ARRAY(subselect) construct?

Something like this:

CREATE TYPE varchar2_table_t AS TABLE OF VARCHAR2(32767);
SELECT job, CAST(MULTISET(SELECT ename FROM emp WHERE job = e.job) AS
varchar2_table_t) FROM emp e GROUP BY job;

-- 
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation                | fax: 732.331.1301
499 Thornall Street, 2nd Floor          | jonah.harris@enterprisedb.com
Edison, NJ 08837                        | http://www.enterprisedb.com/