Below query helps you get the amount in words and also in camel case
SELECT INITCAP(TO_CHAR(TO_DATE(ROUND(AMOUNT),'J'),'JSP')) AS AMOUNT_WORDS_CAMEL_CASE FROM DH_EXPLORATION;
Below screenshot is self explanatory,
In the query mentioned, TO_DATE is used to get the amount in words and INITCAP is used to get the amount in words as camel case.
Learnings : From GIB
SELECT INITCAP(TO_CHAR(TO_DATE(ROUND(AMOUNT),'J'),'JSP')) AS AMOUNT_WORDS_CAMEL_CASE FROM DH_EXPLORATION;
Below screenshot is self explanatory,
In the query mentioned, TO_DATE is used to get the amount in words and INITCAP is used to get the amount in words as camel case.
Learnings : From GIB
I was following your blog regularly and this one is very interesting and knowledge attaining. Great effort ahead. you can also reach us for web development company in chennai website design company in chennai
ReplyDeleteThe Article is good, really helpful and knowledge attaining
ReplyDeleteSofa Cleaning Services in Chennai
Sofa Renovation in Chennai
Sofa Repair in Chennai
Sofa Upholstery in Chennai
Car Seat Upholstery in Chennai
Thanks for sharing this blog. It was so informative.
ReplyDeleteBest IT company for freshers
Good companies for freshers
This comment has been removed by the author.
ReplyDelete