Pivots in Oracle

[Quoted] I'm looking for stategies for multi-joining a single table in Oracle. I [Quoted] imagine there must be some. Here is what I need to do:

I have a table that holds financial records stored on a monthly basis. For a given set of criteria including year, I need to return a set of records that descrbe the financial activity over that year, eg

Criteria... Jan Feb Mar April May etc.

The approach I'm following runs rather sluggish, eg: With a SQL statement I instantiate 12 copies of the table with each copy [Quoted] bringing back the particular month of interest, stringing all 12 together for the complete yearly view of each record.horizontally.

Are there better ways to do this, or should I sharpen up my performance [Quoted] tuning skills?

I'm running Oracle 8i.

Thanks,
Dave Godbey Received on Mon Oct 23 2000 - 06:47:58 CEST