Oracle - Set Every First Letter of A Word In Uppercase

Posted by Agung Pambudi in ,
Oracle Query. (source:

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