Oracle Database Express Edition (XE)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Instead of 'US' or 'GB', return 'EN' for "select sys_context('userenv','local') from dual"

User_06JOCApr 9 2015 — edited Apr 10 2015

How to make following query return 'EN' instead of 'US' or 'GB'

[select sys_context('userenv','local') from dual]

Default tables for user HR in XE has language column values as 'EN', but my locale returns 'US' because of which some of my applications are not returning correct data.

I tried setting NLS_LANG with different options, but they return 'GB', but I want to have 'EN'

thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on May 8 2015

Added on Apr 9 2015

1 comment

849 views