Tuesday, March 24, 2015

Get Amount in words from query : SQL Developer

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  

4 comments:

  1. Replies
    1. Machine Learning Projects for Final Year machine learning projects for final year

      Deep Learning Projects assist final year students with improving your applied Deep Learning skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include Deep Learning projects for final year into your portfolio, making it simpler to get a vocation, discover cool profession openings, and Deep Learning Projects for Final Year even arrange a more significant compensation.

      Python Training in Chennai Python Training in Chennai Angular Training

      Delete
  2. 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

    ReplyDelete