with y 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
)
select
value as language,
y.mon,
to_char(y.monn, 'MONTH', q'|nls_date_language='|' || value || q'|'|') month,
to_char(y.monn, 'MON', q'|nls_date_language='|' || value || q'|'|') month_s
from v$nls_valid_values n, y
where n.parameter='LANGUAGE'
order by language, y.monn
TRADITIONAL CHINESE looks easy
