The INITCAP function returns a string where the initial letter of each word is in uppercase and the other letters are in lowercase.
Syntax
INITCAP(c1)
Parameters
| Parameter | Description |
|---|---|
| c1 | The string. The string type can be CHAR, VARCHAR2, NCHAR, or NVARCHAR2. |
Return type
The data of the CHAR type is returned.
Examples
Execute the following statement:
SELECT initcap('smith abc aBC') upp FROM DUAL;
The following query result is returned:
+------------------+
| UPP |
+------------------+
| Smith Abc Abc |
+------------------+