I just installed 4.0EA3 and it seems to be ignoring the NLS settings in preferences completely.
NLS settings are (amongst others)
NLS_DATE_FORMAT => DD-MM-YYYY H24:MI:SS
NLS_NUMERIC_CHARACTERS => .,
However dates in a grid are returned as 11-NOV-13
and select to_number(1.1) from dual results in ORA01722
Only after executing
alter session set nls_date_format='dd-mm-yyyy hh24:mi:ss';
ALTER SESSION SET NLS_NUMERIC_CHARACTERS = ',.';
things work are supposed.
is this a bug?
I wasn't able to reproduce this. SYSDATE from DUAL with NLS_DATE_FORMAT of DD-MON-RR HH.MI.SS gave me