Mascara

[MiroParticipante]

a entrada é assim 12451734053, gostaria que sai-se assim 124.51734.05.3

select replace(‘12451734053′,’.’,”)
from dual

[quote=”Litz”:3cl5n77v]Faz assim:

select replace(‘124.51734.05.3′,’.’,”)
from dual

Vlw Leonardo Litz[/quote]