On 10/12/07, Andreas Joseph Krogh <[EMAIL PROTECTED]> wrote:
> > 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;
>
> Amazing! Works like a
On Friday 12 October 2007 17:02:23 Jonah H. Harris wrote:
> On 10/12/07, Andreas Joseph Krogh <[EMAIL PROTECTED]> 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 VARCHAR
On 10/12/07, Andreas Joseph Krogh <[EMAIL PROTECTED]> 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 =
