Purpose
The INITCAP function returns a string with the first letter of each word capitalized and the rest of the letters in lowercase. Words are separated by spaces or non-alphanumeric characters.
Syntax
INITCAP(char)
Parameters
char specifies the string. The string can be of type CHAR, VARCHAR2, NCHAR, or NVARCHAR2.
Return type
Returns data of type CHAR.
Examples
Capitalize the first letter of each word in the string ABC def,gHI.
obclient> SELECT INITCAP('ABC def,gHI') STR FROM DUAL;
+-------------+
| STR |
+-------------+
| Abc Def,Ghi |
+-------------+
1 row in set