Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Query Resultset
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
Received on Wed Jan 03 2007 - 11:24:38 CST
![]() |
![]() |