Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 80 of 166
nlssort::=
nlssort
NLSSORT
returns the string of bytes used to sort char.
Both char and nlsparam can be any of the datatypes CHAR
, VARCHAR2
, NCHAR
, or NVARCHAR2
. The string returned is of RAW
datatype.
The value of 'nlsparams' can have the form
'NLS_SORT = sort'
where sort is a linguistic sort sequence or BINARY
. If you omit 'nlsparams', this function uses the default sort sequence for your session. If you specify BINARY
, this function returns char.
Note:
This function does not support |
This function can be used to specify comparisons based on a linguistic sort sequence rather than on the binary value of a string. This example assumes a test table with a name
column containing two values:
SELECT * FROM test ORDER BY name; NAME --------------- Gaardiner Gaberd SELECT * FROM test ORDER BY NLSSORT(name, 'NLS_SORT = XDanish'); NAME --------------- Gaberd Gaardiner
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|