In order to set SQL*PLUS session so that NLS_DATE_FORMAT information is altered in a

[valexena]

In order to set SQL*PLUS session so that NLS_DATE_FORMAT information is
altered in a specific way every time I log into Oracle which method
would be used?
--
Posted via http://dbforums.com

[Hans Forbrich]

valexena wrote:

In order to set SQL*PLUS session so that NLS_DATE_FORMAT information is
altered in a specific way every time I log into Oracle which method
would be used?

--
Posted via http://dbforums.com

One of several could be used, invoked at 'login' time. These are
discussed in the SQL*Plus reference manual found at
http://docs.oracle.com - a searchable site.

--
/Hans
[mailto:`echo $from" | sed "s/yahoo/telusplanet/g"`]

[Bliss]

Hi,

Assuming you are using Windows, you could try adding / changing the registry
entry for NLS_DATE_FORMAT (under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE) to the
desired date format.

Hope that helps.

Regards,
Bliss

[Ping]

PUT

alter session set NLS_DATE_FORMAT = 'MM-DD-YYYY HH24:MI:SS';
in a file named login.sql in the current directory. OR

The login.sql file can also be placed in env. variable SQLPATH