--INITCAP

--Example 1
SELECT INITCAP('Once upon a time...') AS testvalue
FROM dual;


--Example 2
SELECT INITCAP('To BE or NOT TO BE') AS testvalue
FROM dual;


--Example 3
SELECT INITCAP('this is the end') AS testvalue
FROM dual;


--Example 4
SELECT INITCAP('WHAT IS THE TIME? I DO NOT KNOW') AS testvalue
FROM dual;

http://www.databasestar.com/oracle-initcap/

A few examples of the INITCAP function.

Oracle INITCAP Function

sql, Oracle

SQL