SQL & PL/SQL

Hi,

I need experts help in populating the calender dimension with the table structure as below. I need to populate this table from year 1900 to 2100. I was able to get the sql queries for some of the columns from web but could not find any help for most columns like 'DAY_IN_QUARTER'. If somebody could help me with a PL/SQL procedure to populate this table, I really appreciate your help. I know this is too much to ask for, but I have a time constraint in completing this!! :-(

DM_CALENDAR_ID is the primary kay with date in julian format.

Thanks in advance,
Ganesh

Calendar Dimension Table:

DM_CALENDAR_ID
DAY_NAME
DAY_ABBREVIATION
DAY_IN_WEEK
DAY_IN_MONTH
DAY_IN_QUARTER
DAY_IN_YEAR
WEEKDAY_IN_WEEK
WEEKDAY_IN_MONTH
WEEKDAY_IN_QUARTER
WEEKDAY_IN_YEAR
IS_MONTH_START_WEEKDAY
IS_QUARTER_START_WEEKDAY
IS_YEAR_START_WEEKDAY
IS_MONTH_END_WEEKDAY
IS_QUARTER_END_WEEKDAY
IS_YEAR_END_WEEKDAY
IS_MONTH_END
IS_QUARTER_END
IS_YEAR_END
DAYS_TO_GO_IN_MONTH
DAYS_TO_GO_IN_QUARTER
DAYS_TO_GO_IN_YEAR
WEEKDAYS_TO_GO_IN_MONTH
WEEKDAYS_TO_GO_IN_QUARTER
WEEKSDAYS_TO_GO_IN_YEAR
MONTH_ID
MONTH_LONG
MONTH_SHORT
MONTH_NUMBER_IN_YEAR
MONTH_NUMBER_IN_QUARTER
DAYS_IN_MONTH
WEEKDAYS_IN_MONTH
QUARTER_ID
QUARTER_NAME
QUARTER_NUMBER_IN_YEAR
DAYS_IN_QUARTER
WEEKDAYS_IN_QUARTER
YEAR_ID
DAYS_IN_YEAR
WEEKDAYS_IN_YEAR
CREATE_LOAD_DATE
CREATE_LOAD_USER_NAME