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

"This transmission (including any attachments) may contain confidential information, privileged material (including material protected by the attorney-client or other applicable privileges), or constitute non-public information. Any use of this information by anyone other than the intended recipient is prohibited. If you have received this transmission in error, please immediately reply to the sender and delete this information from your system. Use, dissemination, distribution, or reproduction of this transmission by unintended recipients is not authorized and may be unlawful."



Oracle LazyDBA home page