Re: NLS_DATE_FORMAT on NT client

From: Param <paramjit.sublok_at_citicorp.com>
Date: Thu, 30 Jul 1998 09:55:42 +0530
Message-ID: <35BFF5C6.A52A4C3A@citicorp.com>

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 Wed Jul 29 1998 - 23:25:42 CDT