-- -----------------------------------------------------------------------------
-- 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
This Blog for Sharing Knowledge that related to Oracle ERP EBS R12 -------------------------------------------------------------------------------------------------------------------------- *note :- some topics are copied just to share the knowladge*
Subscribe to:
Post Comments (Atom)
SQL Query to Convert number into Words for Money
SELECT INITCAP ( DECODE ( FLOOR (TO_NUMBER ( :amount)), 0, '', TO_CHAR (TO_DATE...
-
You are not setup as a worker. To access this Page you need to be a worker. EBS R12 this is the problem How to solve it...
-
case we needs to Download The HR Workflow but instead of English Descriptions and all the Subjects we needs to appears it by Arabic languag...
No comments:
Post a Comment