SQL INITCAP() Function

SQL INITCAP() Function return capitalize string/char (capitalize first letter of each word).

SQL INITCAP() function supported Oracle SQL version

  • Oracle 8i
  • Oracle 9i
  • Oracle 10g
  • Oracle 11g
  • Oracle 12c
  • Oracle 18c

Syntax

INITCAP(string)

Example

Consider following example return the capitalize string of given string argument.

SQL> SELECT INITCAP('opal kole') "INITCAP" FROM DUAL;

INITCAP
---------
Opal Kole