NLS_LOWER |
NLS_LOWER(string[, 'NLS_SORT=sort']) |
Performs like LOWER, but uses the national character set.
Parameters
sting
Specifies the input character string.
sort
Specifies the name of the linguistic sort sequence specifying capitalization rules for the language being used.
Example
SQL> SELECT NLS_LOWER('MONEY','NLS_SORT=XFRENCH') 2 FROM dual; NLS_L ----- money
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.