From: "Nascar" Newsgroups: comp.databases.oracle.misc References: <8FA97D575DougEdmunds@199.2.117.165> Subject: Re: Changing default date format at instance level Lines: 26 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.3018.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 Message-ID: Date: Sat, 09 Sep 2000 15:38:48 GMT NNTP-Posting-Host: 63.254.25.93 X-Complaints-To: abuse@flash.net X-Trace: news.flash.net 968513928 63.254.25.93 (Sat, 09 Sep 2000 10:38:48 CDT) NNTP-Posting-Date: Sat, 09 Sep 2000 10:38:48 CDT Organization: FlashNet Communications, http://www.flash.net They are referring to the init.ora file for the instance. "doug edmunds" wrote in message news:8FA97D575DougEdmunds@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