Initcap changes the first (initial) letter of a word (string) or series of words into uppercase : INITCAP « Character String Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Character String Functions
  3. INITCAP

The general format for this function is:

SQL> --INITCAP(string)
SQL>
SQL> SELECT INITCAP('capitals') FROM dual;

INITCAP(
--------
Capitals

SQL>








11.5.INITCAP
11.5.1.Initcap changes the first (initial) letter of a word (string) or series of words into uppercase
11.5.2.Use INITCAP() with table column
11.5.3.Capitalized the employee name