How to get the user DB language set for an user?
SELECT USERENV ('language') FROM DUAL;
gives the session's _ but the DATABASE character set not the client, so the value returned is not the client's complete NLS_LANG setting!SELECT * FROM NLS_SESSION_PARAMETERS
gives all the NLS session parameters
No comments:
Post a Comment
Os comentários são moderados.
The comments are moderated.