Hi all,

i have an external table definition which works fine with floats as long as they got a dot for the decimal place.

If they got a comma they get rejected. But those files are exported by Oracle as flat files. Can i adjust the export to do it right or can i do a number conversion like i can do with the SQL Loader?

(TO_NUMBER does not work :-( )

Thanks alot

/F#