Re: create columns from rows in a query

> 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... Received on Fri Feb 14 2003 - 08:59:02 CST