hi ,
if i have a number column , with the values
100 000
200 000
if i use to_char(column , 99,999) , i will get '####....' , because i have 100 and 200 ,
so , i have a table which has many values whic i do not know , may be there is a value '10000 000'
, how to deal with such this situation ? should i include many 9's before and after the comma to avoid #'s ?
like so 9999999,99999999 ?
thank you