Pivots in Oracle 8i

From: Dave Godbey <luhbey_at_erols.com>
Date: Mon, 23 Oct 2000 00:26:42 -0400
Message-ID: <39F3BE01.29260193@erols.com>

I'm looking for stategies for multi-joining a single table in Oracle. I 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 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 tuning skills?

I'm running Oracle 8i.

Thanks,
Dave Godbey Received on Sun Oct 22 2000 - 23:26:42 CDT