| NLS_PARAMETER (merged) [message #117476] |
Wed, 27 April 2005 08:28  |
Shanavas. Y
Messages: 5
Registered: November 2004
|
Junior Member |
|
|
Hi All,
Please Provide One solution to Change NLS_Parameter in MYComputer->Properties->Advanced->Environment variable thru SQL Command or D2k Programming.
With Thanks in advance & regards,
Shan
|
|
|
|
| NLS_PARAMETER [message #117479 is a reply to message #117476] |
Wed, 27 April 2005 08:29  |
Shanavas. Y
Messages: 5
Registered: November 2004
|
Junior Member |
|
|
Hi All,
Please Provide One solution to Change NLS_Parameter in MYComputer->Properties->Advanced->Environment variable thru SQL Command or D2k Programming.
With Thanks in advance & regards,
Shan
|
|
|
|
| Re: NLS_PARAMETER [message #117781 is a reply to message #117476] |
Fri, 29 April 2005 10:18 |
shibu.varghese
Messages: 15
Registered: April 2005
Location: Trivandrum
|
Junior Member |
|
|
From SQL Prompt do the following
I am changing the NLS_DATE_FORMAT which is an NLS_PARAMETER.
(Check out SELECT * FROM V$NLS_PARAMETERS)
begin
execute immediate 'alter session set nls_date_format='||'''dd-mm-yyyy''';
end;
Hope this helps u.
Regds,
Shibum@ibsplc.com
|
|
|
|
| Re: NLS_PARAMETER [message #117829 is a reply to message #117781] |
Fri, 29 April 2005 17:36 |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
You can change NLS_LANG in the registry (if you know what you are doing), or set an environment variable in windows (system > properties > advanced > environment variables as you mentioned) or DOS prompt. Search for NLS_LANG in registry to find the oracle settings.
The "error message" shows your current NLS_LANG:
C:\>sqlplus scott/tiger@dev1
SQL*Plus: Release 9.2.0.1.0 - Production on Fri Apr 29 14:20:57 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
SQL> @%NLS_LANG%
SP2-0310: unable to open file "AMERICAN_AMERICA.WE8MSWIN1252"
SQL>
C:\>set NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
C:\>sqlplus scott/tiger@dev1
SQL*Plus: Release 9.2.0.1.0 - Production on Fri Apr 29 14:24:01 2005
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
With the Partitioning option
JServer Release 8.1.7.4.0 - Production
SQL> @%NLS_LANG%
SP2-0310: unable to open file "AMERICAN_AMERICA.WE8ISO8859P1"
SQL> |
|
|
|
|
|
|
|
| Re: NLS_PARAMETER [message #117980 is a reply to message #117933] |
Mon, 02 May 2005 07:00 |
 |
Maaher
Messages: 7065
Registered: December 2001
|
Senior Member |
|
|
@Shanavas. Y: Why opening a new topic? I've moved the elder one to this forum and merged them. You can reply in topics you know? No need for duplicates or cross-posts.
MHE
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
