INITCAP

INITCAP returns a specified text expression, with the first letter of each word in uppercase and all other letters in lowercase. Words are delimited by white space or non-alphanumeric characters.

Return Value

VARCHAR2 | NVARCHAR2 | CLOB | NCLOB

Syntax

INITCAP(char)

Arguments

char can be any text expression.

Example

INITCAP('top ten tunes') returns the string Top Ten Tunes.