Decimal point problems with Sql Export Results

[Richard Rodz]

hi, when i try to export results thru SQL FILE

the decimal separator (,) is transformed to period (.)

i changed the registry , the NLS_LANGUAGE and the problem persists.

any help please

thanks in advanced

 

[Marco Kalter]

Literal numeric values in SQL expressions are always specified with a period as decimal separator. You cannot use a comma in this case.

 

[Richard Rodz]

Hi, thanks for your quickly answer,

but a varchar2 field too?

I meant,

i create this table:

create table EMA_TARIFAS
(
empresa NUMBER(2) not null,
ramo NUMBER(4) not null,
codtarifa NUMBER(3) not null,
cobertura NUMBER(4) not null,
codigo1 VARCHAR2(10) not null,
codigo2 VARCHAR2(10),
codigo3 VARCHAR2(10),
codigo4 VARCHAR2(10),
.... and so on (more fields)

if you see the field codigo2 is a Varchar2(10)

now

the following query:

SELECT codigo2 FROM ema_tarifas

with the results:

1000000,01
1000000,01
1200000,01
1200000,01
150000,01
150000,01
1500000,01
1500000,01
2000000,01
2000000,01
21
21
21
21
300000,01
300000,01
450000,01
450000,01
50
50
50
50
600000,01
600000,01

if you see some values are 300000,01 etc etc

all with a comma as separator.

when i export them to a SQL FILE:

i get this result:

insert into ema_tarifas (CODIGO2)
values ('1000000.01');

insert into ema_tarifas (CODIGO2)
values ('1000000.01');

insert into ema_tarifas (CODIGO2)
values ('1200000.01');

insert into ema_tarifas (CODIGO2)
values ('1200000.01');

insert into ema_tarifas (CODIGO2)
values ('150000.01');

insert into ema_tarifas (CODIGO2)
values ('150000.01');

insert into ema_tarifas (CODIGO2)
values ('1500000.01');

insert into ema_tarifas (CODIGO2)
values ('1500000.01');

insert into ema_tarifas (CODIGO2)
values ('2000000.01');

insert into ema_tarifas (CODIGO2)
values ('2000000.01');

insert into ema_tarifas (CODIGO2)
values ('21');

insert into ema_tarifas (CODIGO2)
values ('21');

insert into ema_tarifas (CODIGO2)
values ('21');

insert into ema_tarifas (CODIGO2)
values ('21');

insert into ema_tarifas (CODIGO2)
values ('300000.01');

insert into ema_tarifas (CODIGO2)
values ('300000.01');

insert into ema_tarifas (CODIGO2)
values ('450000.01');

insert into ema_tarifas (CODIGO2)
values ('450000.01');

insert into ema_tarifas (CODIGO2)
values ('50');

insert into ema_tarifas (CODIGO2)
values ('50');

insert into ema_tarifas (CODIGO2)
values ('50');

insert into ema_tarifas (CODIGO2)
values ('50');

insert into ema_tarifas (CODIGO2)
values ('600000.01');

insert into ema_tarifas (CODIGO2)
values ('600000.01');

Why the decimal symbol is turned in a point instead a comma as the original?

it

 

[Marco Kalter]

No, this seems like a bug. We'll investigate and will fix it.