Oracle SQL function initcap ()

Initcap ()

Suppose C1 is a string. The function initcap () is to uppercase the first letter of each word, and other letters are converted to lowercase to return.

A word is limited by spaces, control characters, punctuation marks, and other non-alphanumeric characters.

Select initcap ('Hello World') from dual;

Result

Initcap ('He

-----------

Hello World

Select initcap ('Han ello world, Han elloworld, hello Han world, hello Han World') from dual;

Result

Initcap ('Han elloworld, Han elloworld, hello Han world, hello

---------------------------------------------------

Han ello world, Han elloworld, hello Han world, hello Han world