Re: Anti-pivot

On Apr 22, 5:00=A0am, Mountain...@[EMAIL PROTECTED]
 wrote:
> > This works with Oracle 10g XE and Mark's sample data:
>
> This works a treat - many thanks.
>
> Oaf

Urs, yes very nice plus it finishes the job I started since by the
time I figured out the minor error I made while writing the query and
posted I left out the final pivot of the columns into rows.

-- Mark D Powell --