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 w  w. j a v  a2s .c  o  m
SQL> SELECT INITCAP('test') FROM dual
  2