Re: Changing default date format at instance level

From: Nascar <nascar_at_flash.net>
Date: Sat, 09 Sep 2000 15:38:48 GMT
Message-ID: <cQsu5.803$oc3.77339@news.flash.net>

They are referring to the init.ora file for the instance.

"doug edmunds" <dae_alt3_at_juno.com> wrote in message news:8FA97D575DougEdmunds_at_199.2.117.165...
> The Oracle manual says:
> "You can alter the default value of NLS_DATE_FORMAT by changing its value
> in the initialization file and then restarting the instance, and you can
> alter the value during a session using an ALTER SESSION SET
NLS_DATE_FORMAT
> command. "
>
> Which initialization file are they referring to?
> How does the entry in the initialization file read for
> a default entry of 'YYYY-MM-DD'?
>
> I put the alter session line into glogin.sql and it works,
> but it is lost on a 'connect different_user' in the same
> sqlplus session.
>
> --
> Doug Edmunds
> Vancouver, Washington USA
> edmunds::at::pacifier::dot::com
> g
Received on Sat Sep 09 2000 - 10:38:48 CDT