Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Query Help
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 damorgan_at_x.washington.edu (replace x with u to respond) Puget Sound Oracle Users Group www.psoug.orgReceived on Thu Jan 25 2007 - 12:18:18 CST