I have a value 111.111.122.000,00 which is italian format, but while storing in database table i want to make it as 111111122000.00
I can do this using replace or regular expression like
select replace(replace('111.111.122.000,00','.'),',','.') from dual;
but is there any other way like change the NLS_NUMERIC_CHARACTERS and change value before inserting into table.