By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,417 Members | 1,856 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,417 IT Pros & Developers. It's quick & easy.

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

P: n/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
Share this Question
Share on Google+
3 Replies


P: n/a
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

P: n/a
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

P: n/a
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.