Oracle - Set Every First Letter of A Word In Uppercase

Posted by Agung Pambudi on
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;


No comments:

Post a Comment