Re: Query Resultset

Muggle wrote:
> Hello everyone,
>
> I need to execute a complex query and I have managed to generate the
> following resultset
>
> ID STATUS VALUE
> -------------------------------------
>
> 1 A value1
> 1 B value2
> 1 C value3
> 2 A value4
> 2 B value5
> 2 C value6
> 3 A value7
> 3 B value8
> 3 C value9
>
> Using this result I want to generate the following resultset
>
> ID ST_A ST_B ST_C
> --------------------------------------------------------
> 1 value1 value2 value3
> 2 value4 value5 value6
> 3 value7 value8 value9
>
> Can I do that using a query ? Or should do it programmatically in the
> application that retrieves the first resultset ?
>
> Thanks in advance
> Muggle

Go to Morgan's Library at www.psoug.org
click on DECODE

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org