Re: create columns from rows in a query

From: DA Morgan <damorgan_at_exesolutions.com>
Date: Fri, 14 Feb 2003 08:34:48 -0800
Message-ID: <3E4D1AA8.55FC1B2A@exesolutions.com>

Alberto wrote:

> > You can do it with CASE and TRANSLATE but the circumstances under which
> > they would work will be substantially different. I'd say stick with
> > DECODE unless you have a compelling reason to need the other
> > functionality.
>
> I was wondering if there is the possibility to create columns
> automatically without even knowing at desing time how many of them
> there will be (example, a different column for every different value
> of the mail field).
>
> I don't think it is possibile...

It isn't. Actually it isn't in any other product either. They just put a wrapper around the functionality which is something you could write too if you wished.

Daniel Morgan Received on Fri Feb 14 2003 - 10:34:48 CST