Nope that's it. Case/decode is the shortest/best way.

Mike
[Email address protected]
NTP Communications

----- Original Message -----
From: "John Mastrangelo "
<oracledba-ezmlmshield-x80910834.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Wednesday, June 30, 2004 3:14 PM
Subject: Function


> Hi All,
>
> I am trying to find out if there is a oracle function can take data that
is stored vertically in a column in a table and create a cross tab.
>
> I currently use the 'case' 'decode' statement. I also know that PL/SQL
can accomplish this.
>
> Is there a shorter route.
>
> I want to place the data in monthly buckets.
>
>
> With Kindest Regards,
>
> John Mastrangelo, CGA OCP
> Data Warehouse DBA Architect
> Business Intelligence
> Research In Motion Limited
> 295 Phillip Street
> Waterloo, Ontario N2L 3W8
> Voice: (+1) 519 888-7465 Ext. 3735
> E-mail: [Email address protected]
> http://www.rim.com
>

Oracle LazyDBA home page