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>-- from w  ww .ja  v  a 2s.  c  om
SQL> SELECT INITCAP('test') FROM dual
  2