René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback
 

initcap [Oracle SQL]

initcap (character-expression)
Initcap returns character-expression with each word's first character in uppercase and the rest in lowercase.
create table initcap_ex (
  str varchar2(30)
);

insert into initcap_ex values ('in vIno veRitAS');
insert into initcap_ex values ('UrBi ET orbi');
insert into initcap_ex values ('o tempora,o mores');

select initcap (str) from initcap_ex;
INITCAP(STR)
------------------------------
In Vino Veritas
Urbi Et Orbi
O Tempora,O Mores