SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

number format convert

585759Jan 26 2010 — edited Jan 27 2010

Hi

I have an external table that is using German number format.

i.e. 100,00 would be 100.00 in English.

Lets say the data is help in GE_CSV table.

SELECT REVENUE FROM GE_CSV

would return:

100,00
200,00
300,00

etc

What is the best way to convert this into a English number format.

Best Regards
Adam

This post has been answered by 730428 on Jan 27 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 24 2010

Added on Jan 26 2010

#sql

15 comments

4,591 views