Re: Handling of Year wise data in Database Design
A common solution is to have
CREATE TABLE fiscalyears(
yr YEAR -- eg 2007
startdate DATE, -- eg 1 Apr 2007
enddate DATE, -- eg 31 Mar 2008
comment CHAR(128)
);
You keep a row for every fiscal year, and either maintain a yr column in all other tables or join to those tables on fiscalyears.yr=YEAR(revenue.datecol).
PB
Edited 1 time(s). Last edit at 11/27/2007 11:48AM by Peter Brawley.
Subject
Written By
Posted
November 27, 2007 07:07AM
Re: Handling of Year wise data in Database Design
November 27, 2007 11:03AM
November 27, 2007 11:52PM
November 28, 2007 11:43PM
November 29, 2007 05:39PM
November 30, 2007 01:29AM
November 30, 2007 12:35PM
November 28, 2007 10:31AM
November 29, 2007 02:45AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.