469,900 Members | 1,624 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,900 developers. It's quick & easy.

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


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
Jul 19 '05 #1
3 14852
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"`]
Jul 19 '05 #2
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
Jul 19 '05 #3
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
Jul 19 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Ruben Schoenefeld | last post: by
3 posts views Thread by khangu | last post: by
3 posts views Thread by Peter | last post: by
2 posts views Thread by Ant | last post: by
8 posts views Thread by Andrew Teece | last post: by
1 post views Thread by Robin9876 | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.