Optionally enclosed
580927Jul 1 2010 — edited Jul 1 2010Hi,
i have to read a data which comes with " ". But we have some data in between which are also enclosed by quotes.
say for eg., " I come from "London" city"
How can i handle this. When this kind of data is coming, sql loader is just skipping that record.
My control file looks like
fields terminated by "," optionally enclosed by '"' trailing nullcols