INITCAP function in Oracle

INITCAP is one of the vital string/char functions of Oracle. It is used to set the first character in each word to UPPERCASE. The rest characters are set to lowercase. The INITCAP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i.

Syntax:

INITCAP( string )

Parameters:
string: : It is used to specify the string to set.

Example 1:

INITCAP (‘HELLO WORLD’)

Output:

 ‘Hello World’

Explanation:
The first character in each word is left as UPPERCASE and the rest characters are set to lowercase.

Example 2:

INITCAP (‘hello world’)

Output:

 ‘Hello World’

Explanation:
The first character in each word is set to UPPERCASE and the rest characters are left as lowercase.

Please Share