| NLS_SORT [message #119340] |
Thu, 12 May 2005 00:52  |
KHOS
Messages: 10
Registered: April 2005
Location: iran-mashhad
|
Junior Member |
|
|
|
HOW CAN I USE NLS_SORT ?
|
|
|
|
| Re: NLS_SORT [message #119344 is a reply to message #119340] |
Thu, 12 May 2005 01:29  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
Use a command like follows:
With the ALTER SESSION statement
ALTER SESSION SET NLS_SORT = FRENCH;
In SQL functions
TO_CHAR(hiredate, 'DD/MON/YYYY', 'nls_date_language = FRENCH')
"NLS_SORT specifies the type of sort for character data. It overrides the default value that is derived from NLS_LANGUAGE."
It can also be set through an initialization parameter or an environment variable.
This information was taken from:Oracle® Database Globalization Support Guide, 10g Release 1 (10.1), Part Number B10749-02
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
