Re: pivoting tables into columns

"kes" <abirch_at_gmail.com> a écrit dans le message de news: 1151761978.508662.190950_at_v61g2000cwv.googlegroups.com...
| ianal Vista wrote:
| > "Alexander Birch" <abirch_at_gmail.com> wrote in
| <snip>
| >
| > GOOGLE is your friend, but only if you use it.
| >
| > http://asktom.oracle.com -- has many fine coding examples.
|
| I was actually going to ask Tom, yet he's not taking questions. Most of
| his examples use decode (sample_id, max(result), ...)
|
| This is nice if you want an aggregate function, but I want the results
| that are not exactly pivoted. I did do the normal 30 minutes of
| googling and couldn't find any easy way of doing this.
|
| Are there any key words that I am missing?
|
| Thank you for your response.
| Alex
|

If you want Tom answer you I advice to post the create and insert statements for him to build the example and show you how to handle it.

I think you should do the same here and I'm pretty sure some of us have a closer look at your question as we have no time to spend building *your* test case.

Moreover giving the full Oracle version is mandatory to get an accurate answer as this one highly depends on it.

Regards
Michel Cadot Received on Sat Jul 01 2006 - 09:42:11 CDT