Mega Code Archive

 
Categories / Oracle PLSQL Tutorial / Character String Functions
 

Initcap changes the first (initial) letter of a word (string) or series of words into uppercase

The general format for this function is: SQL> --INITCAP(string) SQL> SQL> SELECT INITCAP('capitals') FROM dual; INITCAP( -------- Capitals SQL>