Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

INITCAP a sentence

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