change default nls_date_format for all sessions

From: <tienlee_at_mailexcite.com>
Date: Wed, 14 Apr 1999 21:34:20 GMT
Message-ID: <7f31ks$gk$1@nnrp1.dejanews.com>

I believe the same question has been asked several times but there was no definite answer.

I included nls_date_format = "DD-MON-RR" in my init.ora file but when I start a new session, the default date format is "DD-MON-YY" confirmed by querying nls_session_parameters and nls_database_parameters. Doing a "alter session set nls_date_format = "DD-MON-RR"" works but I want a more permanent setting.

My question to the Oracle DBA guru is how to set the date format for all startup sessions.

Please help. Thanks.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Apr 14 1999 - 16:34:20 CDT