Oracle Database Express Edition (XE)

Hello everyone,

I have installed Oracle11XE and noticed that it has the following date format:

      SQL> SHOW PARAMETER NLS_DATE_FORMAT

      NAME                                 TYPE        VALUE

      ------------------------------------ ----------- --------

      nls_date_format                      string      RR-MM-DD

I know that I can change the format for the session, like this:

     alter session set nls_date_format = 'DD-MON-YY';

I also know that to change the system parameter I need to do the following:

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

     then restart the database.

However, after I do the latter, the date format is still:

     SQL> select sysdate from dual;

     SYSDATE

     --------

     14-11-19

Could someone tell me why this is happening and correct this?..

Thanks.