Hi,
version 11.2.0.3
Have an external table supplied to us as .csv - example data below it has return characters i the actual columns such as OVER REVVING.
SELECT A VEHICLE GROUP FOR DETAILS,1. Birmingham,1.67,"OVER
REVVING",0.18%,"TOTAL
DISTANCE",240.58,"TOTAL
ENGINE
RUN",10:59:48
externla table definition has
organization external
(
type ORACLE_LOADER
default directory DATA_DIR
access parameters
(
RECORDS DELIMITED BY NEWLINE
SKIP 1
BADFILE 'file.bad'
LOGFILE 'file.log'
DISCARDFILE 'file.discard'
FIELDS TERMINATED BY "," OPTIONALLY ENCLOSED BY '"' LRTRIM
MISSING FIELD VALUES ARE NULL...
How can we ignore the line feeds in the columns to prevent it believing these are actually new records
e.g. is there and option to say filed may include carriage return/line feed within it?
Thanks