Re: Query Question

mike wrote:

> I have a table defined like:
>
> CREATE TABLE ORGS
> (
> NUM INTEGER NOT NULL,
> ID INTEGER NOT NULL
> )
>
> In the table I have like:
>
> num id
> 41 5
> 41 6
> 41 7
> 99 5
> 89 9
>
> I was wondering if there is a method where I can generate a result
> dataset from a sql query that looks like:
>
> 41 5,6,7
> 99 5
> 89 9
>
> My approach currently is to iterate over the result dataset to produce
> this.
>
> Mike

PL/SQL

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)