Oracle Calandar
Hello,
Is there Oracle calendar similar to Teradata system calendar? I'm looking for the same one that will provide data fields listed below.
CALENDAR_DATE |
DAY_OF_WEEK |
DAY_NAME |
DAY_OF_MONTH |
DAY_OF_YEAR |
WEEKDAY_OF_MONTH |
WEEK_OF_MONTH |
WEEK_OF_QUARTER |
WEEK_OF_YEAR |
MONTH_OF_QUARTER |
MONTH_OF_YEAR |
MONTH_NAME |
QUARTER_OF_YEAR |
YEAR_OF_CALENDAR |
WEEK_BEGIN |
WEEK_END |
MONTH_BEGIN |
MONTH_END |
QUARTER_BEGIN |
QUARTER_END |
YEAR_BEGIN |
YEAR_END |
IS_BUSINESS_DAY |
BUSINESS_WEEK_BEGIN |
BUSINESS_WEEK_END |
BUSINESS_MONTH_BEGIN |
BUSINESS_MONTH_END |
BUSINESS_QUARTER_BEGIN |
BUSINESS_QUARTER_END |
BUSINESS_YEAR_BEGIN |