sys_context('userenv','LANG')
Hi,
Oracle Documentaion says that sys_context('userenv','LANG') returns:
The ISO abbreviation for the language name, a shorter form than the existing 'LANGUAGE' parameter.
My assumption was that this function returns language code according to ISO 639. But instead it returns values like that:
D for GERMAN
F for FRENCH
GB for ENGLISH
US for AMERICAN
here is an example:
alter session set nls_language = 'GERMAN'
/
select sys_context('userenv','LANG') from dual
Which function or conversation do i have to use in order to get ISO 639 Code for the current session?
And which ISO abbreviation is meant by Oracle Documentation (i couldn't find any that defines D, F, GB, US ... for language codes)?
Thanks,
Christian