Re: NLS_DATE_FORMAT on NT client

Look in the NT registry. Under hkey_local_machine/software/oracle you'll find the NLS_LANG entry.
This entry sets the default territory, language and character set for your client station.

Otherwise, through an application, use param's advice and go with ALTER SESSION to keep
control.

Sylvain Leclerc
sleclerc_at_magrit.com

> -----Original Message-----
> From: Param [SMTP:paramjit.sublok_at_citicorp.com]
> Posted At: Thursday, July 30, 1998 12:26 AM
> Posted To: server
> Conversation: NLS_DATE_FORMAT on NT client
> Subject: Re: NLS_DATE_FORMAT on NT client
>
> C. Mason wrote:
> >
> > I am using SQLPLUS on an NT machine to connect to an ORACLE
> database
> > on a
> > UNIX server. The NLS_DATE_FORMAT in my SQLPLUS session is different
> > that
> > the NLS_DATE_FORMAT that is set in the initsid.ora file on the
> server.
> > Where do I set the default NLS_DATE_FORMAT on my NT client so that
> it
> > is the
> > same as what is set on the server?
>
> I don't know NT specifics, but on UNIX there is a file called
> glogin.sql
> which is executed everytime you start SQL*Plus. This script file can
> be
> found under ORACLE_HOME/sqlplus/admin. In this script, you can put the
> command
> ALTER SESSION SET NLS_DATE_FORMAT = "YYYYMMDD ....
>
> So whenever you startup SQL*Plus, your NLS_DATE_DORMAT will be set to
> your required format.
>
> Additionally, you can put the same in a script 'login.sql' placed in
> the
> start directory of SQL*Plus.
>
> Param
Received on Thu Jul 30 1998 - 07:10:28 CDT