Hi Everybody,
I have a requirement where all the first character of a word has to capital, i am using below query to do that.
select initcap('The great toad’s prediction') from dual;
Output
---------
The Great Toad’S Prediction
Because of special character S is also coming as caps, which is not correct here.
The actual output should be,
The Great Toad’s Prediction
Could you please help here.