2007-06-19

Como saber a linguagem da BD para um utilizador?

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.