INITCAP a sentence
SQL> SELECT INITCAP('this TEXT hAd UNpredictABLE caSE') FROM DUAL; INITCAP('THISTEXTHADUNPREDICTABL -------------------------------- This Text Had Unpredictable Case SQL>