Change comma by point

[LuColli]

Hello,
I need to export records and I have to change comma in values by point (example 25,30 to 25.30). I looked for it in tools, but I didn

 

[Marco Kalter]

You could use a to_char or replace expression in the query, and export the results.

 

[LuColli]

Marco,
I have to use all the columns from a big table (export from many tables too), so I dont

 

[Gustavo]

Hi Lu,

You could try this before running export:

alter session set nls_numeric_characters='.,';

Abra

 

[Marco Kalter]

Which function do you use to export the tables?

 

[LuColli]

Gustavo, I tried it, but not worked.
Thank you!
Luciana

 

[LuColli]

Marco, I use Export Results/Sql file, after select the records.
Thank you!
Luciana

 

[Marco Kalter]

The numeric format will be as defined in the Windows Regional and Language Options (you can use this as a workaround). This seems like a bug, since it should always use a . as decimal symbol. We'll fix it.

 

[LuColli]

Ok Marco!
Thank you!

 

[LuColli]

Hello Marco!
Was the problem fix?
Thank you!

 

[Marco Kalter]

Yes, it's fixed for the upcoming 7.1.5 release.

 

[LuColli]

Thank you, Marco!

 

[Gustavo]

"A few months" 'till 8.0...

What about 7.1.5? Is there a "what's new" you could put here?