In Oracle/PLSQL, the initcap function sets the first character in each word to uppercase and the rest to lowercase.
Syntax
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 11g, Oracle 10g, Oracle 9i, Oracle 8i
For Example
| initcap('tech on the net'); | would return 'Tech On The Net' |
| initcap('GEORGE BURNS'); | would return 'George Burns' |
