|Oracle9i SQL Reference
Release 1 (9.0.1)
Part Number A90125-01
Functions, 79 of 166
NLS_LOWER returns char, with all letters lowercase.
Both char and nlsparam can be any of the datatypes
NCLOB. The string returned is of
VARCHAR2 datatype and is in the same character set as char.
The nlsparam can have the same form and serve the same purpose as in the
The following statement returns the character string '
citta'' using the XGerman linguistic sort sequence: