Oracle SQL - Function INITCAP function

  1. HOME
  2. Oracle SQL
  3. Function
  4. 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  va 2s.c om
SQL> SELECT INITCAP('test') FROM dual
  2