Hi gurus,

I would like to change the nls_date_format to 'YYYYMMDD' and the
existing server is using the values from 'SPFILE<Oracle_instance>.ORA'.
Is there any way I can modify this and moreover this is a session
variable.

This command works but this is active only for the session.
ALTER SESSION SET NLS_DATE_FORMAT = 'YYYYMMDD';

I want to change at the Oracle server level.

Thanks a lot in advance.

Regards
Rajesh





Oracle LazyDBA home page