Does anyone know if the there is a built in procedure/function in Oracle
for populating a calendar table? The table would look something like this:

CREATE TABLE DATE_DIM
(DATE_KEY NUMBER(22) NOT NULL
,FSA_DATE DATE NOT NULL
,DAY_OF_WEEK VARCHAR2(9) NOT NULL
,DAY_NUMBER NUMBER(22) NOT NULL
,MONTH_NUMBER NUMBER(22,2) NOT NULL
,CALENDAR_YEAR NUMBER(22,4) NOT NULL
,HOLIDAY_INDICATOR VARCHAR2(1)
,WEEKDAY_INDICATOR VARCHAR2(1)
,CALENDAR_QUARTER VARCHAR2(2) NOT NULL
,FISCAL_QUARTER VARCHAR2(3) NOT NULL
)


William R Douglas
CSC at Egg Harbor NJ
609-677-8531


--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please
delete without copying and kindly advise us by e-mail of the mistake in
delivery. NOTE: Regardless of content, this e-mail shall not operate to
bind CSC to any order or other contract unless pursuant to explicit
written agreement or government initiative expressly permitting the use of
e-mail for such purpose.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Oracle LazyDBA home page