Oracle Database 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!