Hello,
as you know, Oracle stores numbers in this format 999999.99
But our currency format is different than this.
For example, in US; sample currency is 1234,56.78 and this number stored as 123456.78 in oracle.
But, the equvalent number in our format is 1234.56,78 (we use ',' for decimal separator and '.' for thousand separator)
So, how can we convert 123456.78 to 123.456,78 (turkish format)
Can you write a sample sql?
Thanks...