Changing case in Oracle

To change the first letter of the word to cap, use the inicap function. Use upper to covert to uppercase and lower to convert to lower case. Examples:

initcap('change case')  -- Change Case
lower('Change Case')    -- change case
upper('change case')    -- CHANGE CASE

These functions work on Oracle 8i, 9i, 10g, and 11g.