External tables and decimal delimiters
Hi!
I try to transfer data from ascii files to the database using external tables. But I have problems with the number format, specifically with the decimal delimiter.
The number format in the ascii files is:
123.456,99
How can I change the decimal delimiter and the group separator for external tables?
Is it possible to use DECIMAL EXTERNAL TO_NUMBER ... (like in SQL Loader)?
Changing the date format is simple, but is there an example how to do it with different number formats?
Any help is very much appreciated.
Erik