Formato numeros

[danielovik]

Hola nuevamente,
me autorespondo.

select to_char(venta,'99,999,990.00'), venta from ventas


0.00 0
0.00 0
1,250.00 1250
250.00 250
3,940.00 3940
7,685.00 7685
930.00 930
11,570.00 11570
2,020.00 2020
27,217.50 27217.5
1,293,750.00 1293750