Re: SQL-question. Please HELP

Me too. I had to write my own perl (DBI/Oraperl) script to do the transform. Cut-pasting into MS-Excel is also a "solution". (Somewhat manual thou). (Would be nice if "pivot" was a built-in feature of SQL I think).

Christer Blomqvist wrote:
>
> Hi there
>
> Is it possible to query an Oracle-db and return the result in a way similar
> to Transform/Pivot in MS Access ??
> Have read the documentation but haven't found a solution.
>
> Regards
>
> Christer Blomqvist
 

-- 
Kjetil Skotheim
kjetilskotheim_at_iname.com