Re: Challenging Question

From: Hans Forbrich <forbrich_at_yahoo.net>
Date: Fri, 17 Sep 2004 22:54:24 GMT
Message-ID: <AWJ2d.67555$XP3.39900@edtnps84>

Raja Botham wrote:

> I look forward to responses based on which I would start working on
> it...
>

Are you looking at creating such a table or does it exist & you are forced to use it? The design pattern is that of a spread sheet and not a database.

If yes, please consider that a database is not a replacement for a spread sheet. In database terms, you will get much better flexibility for future reports by going to a long but narrow table like

Table XX

Date Value
------- -----
Jan 00 3
Jan 01 6
...

Then use a variety of techniques to pivot and cross-tab - saples at Morgan;s library on psoug's site (and iirc, at otn's sample code library).

Other techiques, as well, are documented in O'Reilly's "Mastering Oracle SQL" Received on Fri Sep 17 2004 - 17:54:24 CDT