Skip to content
Advertisement

Formatting bigdecimals sql oracle

To have a readable big numbers under oracle and to facilatet the reading, I’m looking for a way to add blank space to obtain something like that:

213537592384.236 ===> 213 537 592 384.236

The problem that I have big numbers like above.

Advertisement

Answer

Spaces are a curious separator, and not directly supported by to_char(). However, you can format with commas and then replace the commas with spaces:

select replace(to_char(12345678.123, '999,999,999,999,999,999.999'), ',', ' ')
from dual
5 People found this is helpful
Advertisement