[Home] [Help] [Dependency Information]
Object Name: | MTH_GREGORIAN_CALENDAR# |
---|---|
Object Type: | VIEW |
Owner: | MTH |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DIMENSION_KEY | NUMBER | Yes | ||
DAY_DESCRIPTION | VARCHAR2 | (2000) | ||
DAY_NAME | VARCHAR2 | (25) | ||
DAY_START_DATE | DATE | |||
DAY | DATE | |||
DAY_END_DATE | DATE | |||
DAY_OF_CAL_YEAR | NUMBER | |||
DAY_ID | NUMBER | |||
DAY_OF_CAL_WEEK | NUMBER | |||
DAY_OF_CAL_QUARTER | NUMBER | |||
JULIAN_DATE | NUMBER | |||
DAY_TIME_SPAN | NUMBER | |||
DAY_OF_CAL_MONTH | NUMBER | |||
DAY_DAY_CODE | NUMBER | |||
CALENDAR_MONTH_ID | NUMBER | |||
MONTH_OF_YEAR | NUMBER | |||
CALENDAR_MONTH_DESCRIPTION | VARCHAR2 | (2000) | ||
CAL_MONTH_NUMBER | NUMBER | |||
CALENDAR_MONTH_TIME_SPAN | NUMBER | |||
CALENDAR_MONTH_START_DATE | DATE | |||
CALENDAR_MONTH_CAL_MONTH_CODE | NUMBER | |||
CALENDAR_MONTH_NAME | VARCHAR2 | (25) | ||
MONTH_OF_QUARTER | NUMBER | |||
CALENDAR_MONTH_END_DATE | DATE | |||
CALENDAR_QUARTER_TIME_SPAN | NUMBER | |||
CALENDAR_QUART_CAL_QUARTER_CO | NUMBER | |||
CALENDAR_QUARTER_START_DATE | DATE | |||
CALENDAR_QUARTER_END_DATE | DATE | |||
CALENDAR_QUARTER_ID | NUMBER | |||
CALENDAR_QUARTER_DESCRIPTION | VARCHAR2 | (2000) | ||
CAL_QUARTER_NUMBER | NUMBER | |||
CALENDAR_QUARTER_NAME | VARCHAR2 | (25) | ||
QUARTER_OF_YEAR | NUMBER | |||
CALENDAR_YEAR_END_DATE | DATE | |||
CALENDAR_YEAR_ID | NUMBER | |||
CAL_YEAR_NUMBER | NUMBER | |||
CALENDAR_YEAR_NAME | VARCHAR2 | (25) | ||
CALENDAR_YEAR_TIME_SPAN | NUMBER | |||
CALENDAR_YEAR_CAL_YEAR_CODE | NUMBER | |||
CALENDAR_YEAR_DESCRIPTION | VARCHAR2 | (2000) | ||
CALENDAR_YEAR_START_DATE | DATE | |||
CREATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LAST_UPDATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT DIMENSION_KEY
, DAY_DESCRIPTION
, DAY_NAME
, DAY_START_DATE
, DAY
, DAY_END_DATE
, DAY_OF_CAL_YEAR
, DAY_ID
, DAY_OF_CAL_WEEK
, DAY_OF_CAL_QUARTER
, JULIAN_DATE
, DAY_TIME_SPAN
, DAY_OF_CAL_MONTH
, DAY_DAY_CODE
, CALENDAR_MONTH_ID
, MONTH_OF_YEAR
, CALENDAR_MONTH_DESCRIPTION
, CAL_MONTH_NUMBER
, CALENDAR_MONTH_TIME_SPAN
, CALENDAR_MONTH_START_DATE
, CALENDAR_MONTH_CAL_MONTH_CODE
, CALENDAR_MONTH_NAME
, MONTH_OF_QUARTER
, CALENDAR_MONTH_END_DATE
, CALENDAR_QUARTER_TIME_SPAN
, CALENDAR_QUART_CAL_QUARTER_CO
, CALENDAR_QUARTER_START_DATE
, CALENDAR_QUARTER_END_DATE
, CALENDAR_QUARTER_ID
, CALENDAR_QUARTER_DESCRIPTION
, CAL_QUARTER_NUMBER
, CALENDAR_QUARTER_NAME
, QUARTER_OF_YEAR
, CALENDAR_YEAR_END_DATE
, CALENDAR_YEAR_ID
, CAL_YEAR_NUMBER
, CALENDAR_YEAR_NAME
, CALENDAR_YEAR_TIME_SPAN
, CALENDAR_YEAR_CAL_YEAR_CODE
, CALENDAR_YEAR_DESCRIPTION
, CALENDAR_YEAR_START_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
FROM MTH.MTH_GREGORIAN_CALENDAR#;
|
|
|