Problems with LOAD DATA
I load data from CSV files using the LOAD DATA utility. Where there is an embedded comma in text data, the field is enclosed with double quotes, and I am using the clause "OPTIONALLY ENCLOSED BY '"'. Unfortunately, the double quotes are ignored, and the comma is taken to indicate a new field.
Has anyone else had this problem, and if so is there a work-around?
Any help greatly appreciated.
Subject
Written By
Posted
Problems with LOAD DATA
June 21, 2014 02:51AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.