Re: Query Help

Thanks but I don't think that does the same thing unless I am reading it wrong:

http://www.oracle.com/technology/oramag/oracle/06-nov/o66asktom.html

On Jan 25, 11:18 am, DA Morgan <damor..._at_psoug.org> wrote:
> AZNewsh wrote:
> > Sample table:
>
> > ID----------ITEM
> > 1 knife
> > 1 fork
> > 1 spoon
> > 2 fork
> > 2 spoon
> > 3 fork
> > 4 knife
> > 4 fork
> > 4 spoon
>
> > Required output for csv file:
>
> > 1 knife fork spoon
> > 2 fork spoon
> > 3 fork
> > 4 knife fork spoon
>
> > Is this even possible, if so how would the SQL query look?
>
> > Thanks in advance for your time.Look at Tom Kyte's article in the November/December 2006 issue of Oracle
> Magazine. Likely it is also available on-line.
> --
> Daniel A. Morgan
> University of Washington
> damor..._at_x.washington.edu
> (replace x with u to respond)
> Puget Sound Oracle Users Groupwww.psoug.org- Hide quoted text -- Show quoted text -
Received on Thu Jan 25 2007 - 12:26:21 CST