|Oracle® Database SQL Language Reference
11g Release 2 (11.2)
Part Number E17118-03
char, with all letters lowercase.
'nlsparam' can be any of the data types
NCLOB. The string returned is of
VARCHAR2 data type if
char is a character data type and a LOB if
char is a LOB data type. The return string is in the same character set as
'nlsparam' can have the same form and serve the same purpose as in the
The following statement returns the lowercase form of the character string '
NOKTASINDA' using the XTurkish linguistic sort sequence. The Turkish uppercase I becoming a small, dotless i.
SELECT NLS_LOWER('NOKTASINDA', 'NLS_SORT = XTurkish') "Lowercase" FROM DUAL;