Oracle Database String Manipulation INITCAP
Example
The INITCAP function converts the case of a string so that each word starts with a capital letter and all subsequent letters are in lowercase.
SELECT INITCAP('HELLO mr macdonald!') AS NEW FROM dual;
Output
NEW
-------------------
Hello Mr Macdonald!
