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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.