Oracle/PLSQL: Initcap Function

In Oracle/PLSQL, the initcap function sets the first character in each word to uppercase and the rest to lowercase.

The syntax for the initcap function is:

initcap( string1 )

string1 is the string argument whose first character in each word will be converted to uppercase and all remaining characters converted to lowercase.

Applies To:

• Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For example:

initcap('tech on the net');	would return 'Tech On The Net'
initcap('GEORGE BURNS');	would return 'George Burns'