NLS_INITCAP |
NLS_INITCAP(string[, 'NLS_SORT=sort']) |
Performs like INITCAP, but uses the national character set.
Parameters
string
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_INITCAP('money','NLS_SORT=XFRENCH') 2 FROM dual; NLS_I ----- 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.