ORACLE init cap function

ORACLE init cap function

InitCAP   functions makes first letter in each word as Upper case.

Synatx: InitCap(char expr);

SQL>select initcap('hello world') from dual;

       
initcap('hello world')

--------------------------

Hello World

SQL> select initcap(first_name),initcap(last_name),initcap(first_name||' '||last_name) from employees

it makes first_name ,last_name,concatenating name and displays Upper case in each word.