Re: Need SQL guru for TRANSFORM PIVOT statement

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 23 Jul 2003 06:35:16 -0700
Message-ID: <2687bb95.0307230535.3bd7c3da@posting.google.com>

Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<u65ltdfqb.fsf_at_standardandpoors.com>...
> I just posted this link to another question, but it looks like it
> would solve your issue.
>
> http://asktom.oracle.com/pls/ask/f?p=4950:8:::::F4950_P8_DISPLAYID:124812348063

I think Tom was solving a slightly different version of the problem. Billy Verreynne has posted on pivoting and offers three different solutions in his post of "2002-03-11 22:13:08" subject line "Subject: Re: reverse pivoting". I think the pivot table approach may be cleaner for this specific case. The post may be found using google advanced search on newsgroup comp.databases.oracle.server

HTH -- Mark D Powell -- Received on Wed Jul 23 2003 - 08:35:16 CDT