Wednesday, August 17, 2011

NLS parameters

Was having a hard time finding where (if) my NLS parameters were being reflected after I used the ALTER SESSION SET NLS_(parameter) = somevalue.

V$parameter (where the internetz told me to look) wasn't updating.

For the best view of your session/db NLS settings, use NLS_SESSION(or DATABASE)_PARAMETERS


ALTER SESSION SET nls_date_format = "MON-DD-YYYY";


SELECT a.parameter, a.VALUE, b.VALUE, b.ISSES_MODIFIABLE 

FROM NLS_SESSION_PARAMETERS a
LEFT JOIN v$parameter b ON lower(b.NAME) = lower(a.PARAMETER) --Notice no update!

No comments:

Post a Comment