NLSSORT

Syntax

NLSSORT(str [, ' nlsparam '])

Overview

NLSSORT is a function that returns the character bytes used to sort str.

Parameter

Parameter	Description
str	String value for sorting. It can be TEXT or CHAR type data.
nls_param	Parameter that defines the character set to be used for sorting str. It can be TEXT or CHAR type data. It can be defined in the format ‘NLS_SORT=sort’. If not defined, the value defined in the session is used.

Example

SELECT NAME FROM T ORDER BY NLSSORT(NAME);
 name 
------
 BAR
 FOO
(2 rows)