Rachel
Reputation: 103607
How to put commas in numbers without using to_char?
I have variable defined as NUMBER type and it has values like 2314514512 how can I add comma to this number so that it appears like 2,314,514,512 without using to_char?
Upvotes: 0
Views: 1035
Answers (1)
Rachel
Reputation: 103607
I was able to solve the issue as I did formatting part from the reporting tool before rendering data back to the user.
Upvotes: 1
Related Questions
- Number formatting in Oracle using TO_CHAR
- Oracle APEX number format mask without comma
- Formatting number with comma separation, NO TO_CHAR in Oracle
- ORACLE SQL TO_NUMBER string value with comma
- Oracle Format Number With Commas Remove Trailing Zero Decimals
- How to convert a number into a format which will be separated by comma's by position in sql
- oracle sql query to format number by comma
- format a lengthy number with commas in Oracle
- Oracle 11.2 to_number multiple commas
- format decimals and comma to numbers retrieved