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('24X7 information for you'); | would return '24X7 Information For You' |
initcap('ORACLE TECHNOLOGY'); | would return 'Oracle Technology' |
