char, with all letters lowercase.
'nlsparam' can be any of the datatypes
NCLOB. The string returned is of
VARCHAR2 datatype if
char is a character datatype and a LOB if
char is a LOB datatype. 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 character string '
citta'' using the XGerman linguistic sort sequence:
SELECT NLS_LOWER ('CITTA''', 'NLS_SORT = XGerman') "Lowercase" FROM DUAL; Lowerc ------ citta'