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