get user environment language
There is one requirement to get user environment language. I logged into the cloud application with German language to get the expected output. However, when I run the following query to fetch the user environment language. I am getting 'US' instead of 'DE'(Germany), which seems unexpected.
"SELECT userenv('lang') FROM dual"
Could you suggest on how to get the user environment language correctly?
Any guidance on this would be appreciated.
0