All The Dates Query

-- ----------------------------------------------------------------------------- -- Query of 79 languages for the 12 Gregorian calendar months, adapted from -- Mattias Rogel's query -- -- https://marogel.wordpress.com/2012/03/23/learning-foreign-languages-with-oracle-sql/ -- ----------------------------------------------------------------------------- with list_of_months AS ( SELECT add_months(date'2012-01-01', level-1) monn, to_char(add_months(date'2012-01-01', level-1), 'MONTH') mon FROM dual CONNECT BY LEVEL<=12 ) -- END OF list_of_months CTE , langs ( language_nm ) AS ( SELECT 'ALBANIAN' FROM DUAL UNION ALL SELECT 'AMERICAN' FROM DUAL UNION ALL SELECT 'AMHARIC' FROM DUAL UNION ALL SELECT 'ARABIC' FROM DUAL UNION ALL SELECT 'ARMENIAN' FROM DUAL UNION ALL SELECT 'ASSAMESE' FROM DUAL UNION ALL SELECT 'AZERBAIJANI' FROM DUAL UNION ALL SELECT 'BANGLA' FROM DUAL UNION ALL SELECT 'BELARUSIAN' FROM DUAL UNION ALL SELECT 'BENGALI' FROM DUAL UNION ALL SELECT 'BRAZILIAN PORTUGUESE' FROM DUAL UNION ALL SELECT 'BULGARIAN' FROM DUAL UNION ALL SELECT 'CANADIAN FRENCH' FROM DUAL UNION ALL SELECT 'CATALAN' FROM DUAL UNION ALL SELECT 'CROATIAN' FROM DUAL UNION ALL SELECT 'CYRILLIC KAZAKH' FROM DUAL UNION ALL SELECT 'CYRILLIC SERBIAN' FROM DUAL UNION ALL SELECT 'CYRILLIC UZBEK' FROM DUAL UNION ALL SELECT 'CZECH' FROM DUAL UNION ALL SELECT 'DANISH' FROM DUAL UNION ALL SELECT 'DARI' FROM DUAL UNION ALL SELECT 'DIVEHI' FROM DUAL UNION ALL SELECT 'DUTCH' FROM DUAL UNION ALL SELECT 'EGYPTIAN' FROM DUAL UNION ALL SELECT 'ENGLISH' FROM DUAL UNION ALL SELECT 'ESTONIAN' FROM DUAL UNION ALL SELECT 'FINNISH' FROM DUAL UNION ALL SELECT 'FRENCH' FROM DUAL UNION ALL SELECT 'GERMAN DIN' FROM DUAL UNION ALL SELECT 'GERMAN' FROM DUAL UNION ALL SELECT 'GREEK' FROM DUAL UNION ALL SELECT 'GUJARATI' FROM DUAL UNION ALL SELECT 'HEBREW' FROM DUAL UNION ALL SELECT 'HINDI' FROM DUAL UNION ALL SELECT 'HUNGARIAN' FROM DUAL UNION ALL SELECT 'ICELANDIC' FROM DUAL UNION ALL SELECT 'INDONESIAN' FROM DUAL UNION ALL SELECT 'IRISH' FROM DUAL UNION ALL SELECT 'ITALIAN' FROM DUAL UNION ALL SELECT 'JAPANESE' FROM DUAL UNION ALL SELECT 'KANNADA' FROM DUAL UNION ALL SELECT 'KHMER' FROM DUAL UNION ALL SELECT 'KOREAN' FROM DUAL UNION ALL SELECT 'LAO' FROM DUAL UNION ALL SELECT 'LATIN AMERICAN SPANISH' FROM DUAL UNION ALL SELECT 'LATIN BOSNIAN' FROM DUAL UNION ALL SELECT 'LATIN SERBIAN' FROM DUAL UNION ALL SELECT 'LATIN UZBEK' FROM DUAL UNION ALL SELECT 'LATVIAN' FROM DUAL UNION ALL SELECT 'LITHUANIAN' FROM DUAL UNION ALL SELECT 'MACEDONIAN' FROM DUAL UNION ALL SELECT 'MALAY' FROM DUAL UNION ALL SELECT 'MALAYALAM' FROM DUAL UNION ALL SELECT 'MALTESE' FROM DUAL UNION ALL SELECT 'MARATHI' FROM DUAL UNION ALL SELECT 'MEXICAN SPANISH' FROM DUAL UNION ALL SELECT 'NEPALI' FROM DUAL UNION ALL SELECT 'NORWEGIAN' FROM DUAL UNION ALL SELECT 'ORIYA' FROM DUAL UNION ALL SELECT 'PERSIAN' FROM DUAL UNION ALL SELECT 'POLISH' FROM DUAL UNION ALL SELECT 'PORTUGUESE' FROM DUAL UNION ALL SELECT 'PUNJABI' FROM DUAL UNION ALL SELECT 'ROMANIAN' FROM DUAL UNION ALL SELECT 'RUSSIAN' FROM DUAL UNION ALL SELECT 'SIMPLIFIED CHINESE' FROM DUAL UNION ALL SELECT 'SINHALA' FROM DUAL UNION ALL SELECT 'SLOVAK' FROM DUAL UNION ALL SELECT 'SLOVENIAN' FROM DUAL UNION ALL SELECT 'SPANISH' FROM DUAL UNION ALL SELECT 'SWAHILI' FROM DUAL UNION ALL SELECT 'SWEDISH' FROM DUAL UNION ALL SELECT 'TAMIL' FROM DUAL UNION ALL SELECT 'TELUGU' FROM DUAL UNION ALL SELECT 'THAI' FROM DUAL UNION ALL SELECT 'TRADITIONAL CHINESE' FROM DUAL UNION ALL SELECT 'TURKISH' FROM DUAL UNION ALL SELECT 'UKRAINIAN' FROM DUAL UNION ALL SELECT 'VIETNAMESE' FROM DUAL ) -- END OF lang CTE SELECT n.language_nm , y.monn , to_char(y.monn, 'MONTH', q'|nls_date_language='|' || language_nm || q'|'|') "month" , to_char(y.monn, 'MON', q'|nls_date_language='|' || language_nm || q'|'|') "month short)" FROM langs n, list_of_months y ORDER BY 1,2