October 2005
1 post
CSV seperator character
In my particular case I got an excel sheet from the customer to import in a DB. The idea is to use a CSV as the base for an Oracle external table and then import the data in the real table with a “insert into select”.
When I loaded the excel sheet and saved it as a CSV, the semicolon (“;”) was used as a seperator. I therefore created my external table and worked with the...