change nls_date_format oracle

0

My oracle now has:

NLS_DATE_FORMAT     DD/MM/RR
NLS_DATE_LANGUAGE   SPANISH

Then I execute:

alter session set nls_date_format = 'DD-MON-RR';
alter session set NLS_DATE_LANGUAGE = 'AMERICAN';

And it changes it without problems, but when I close my sql developer it returns to the configuration in Spanish, how can I modify it forever?

I've tried:

alter system set nls_date_format = 'DD-MON-RR' scope=spfile;

But it's still the same

    
asked by sirdaiz 18.05.2017 в 17:27
source

0 answers