INITCAP Vs NLS_INITCAP

[rajeshvela]

Hi Friends,
Can any body help me by clarifying the difference between
the functions
INITCAP and NLS_INITCAP

Thanks in Adcance
Rajesh

[jmodic]

In some NLS language settings, the lowercase letters can have special uppercase mappings. Here is an example for German letter 'ß':

SQL> SELECT INITCAP('ßabcd') "Initcap"
2 FROM DUAL;

Initc
-----
ßabcd

SQL> SELECT NLS_INITCAP('ßabcd', 'NLS_SORT = XGerman') "NLS_inicap"
2 FROM DUAL;

NLS_in
------
SSabcd