Hi,


Please inform how can replace decimal operator dot(.) with comma(,) in oracle database

Permanently I want to change it in database.

Also no separator is required for numaric values.All decimal fields of table will accept comma(,) instead of dot(.)

Actually my customer is Sweden based .This is business requirement.

The result of the following statement wil be just like below....

OLD(default)- 1,234.56
NOW- 1234,56


Regards,
Swadesh Mondal

create table t (
  x number
);

insert into t values (1234.56);

alter session set NLS_NUMERIC_CHARACTERS = '.,';

select * from t;

alter session set NLS_NUMERIC_CHARACTERS = ',.';

select * from t;

select to_char(x, '999G999D00') sep, to_char(x, '999990D00') no_sep
from   t;

SEP         NO_SEP   
----------- ----------
   1.234,56    1234,56