Oracle SQL - Function INITCAP function

Introduction

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

The general format for this function is:

INITCAP(string) 

Demo

SQL>
SQL>--   w  ww  .j a v  a  2s. c  om
SQL> SELECT INITCAP('test') FROM dual
  2