Posted By

bbrumm on 02/27/17

Tagged

sql
Oracle

Versions (?)

Last Edited at 02/27/17 07:39am

Statistics

Viewed 944 times

Favorited by 0 user(s)

Related snippets

Oracle INITCAP Function

/ Published in: SQL

A few examples of the INITCAP function.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

--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;