Advanced Search

Return to Snippet

Revision: 71483
at February 27, 2017 07:39 by bbrumm
Initial Code 
--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;
Initial URL 
http://www.databasestar.com/oracle-initcap/
Initial Description 
A few examples of the INITCAP function.
Initial Title 
Oracle INITCAP Function
Initial Tags 
sql, Oracle
Initial Language 
SQL