Oracle - Set Every First Letter of A Word In Uppercase

Oracle Query. (source: www.theopensourcery.com)


How to set every first letter of a word in uppercase and the rest in lowercase ?

Oracle has the INITCAP option


SELECT INITCAP(airlines) AS maskapai,TO_CHAR(dep_time, 'HH24:MI') AS departure,TO_CHAR(arr_time, 'HH24:MI') AS arrive,economi_rate FROM cms_flightdetails where ROWNUM <= 8;

SHARE

About Agung Pambudi

I am a Blogger with passion in business.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment