Does the Oracle LOADER not like '\n' as a delimitor?
From: BEVERLY SEAVEY <nmrdb_at_vms.macc.wisc.edu>
Date: 13 JUL 93 10:56:35
Message-ID: <1993Jul13.160353.28808_at_macc.wisc.edu>
Date: 13 JUL 93 10:56:35
Message-ID: <1993Jul13.160353.28808_at_macc.wisc.edu>
I am generated output files to be loaded by a general loader, i.e., not just oracle, but Sybase and Ingres too.
The problem I am having is that I want to delimit some of fields with
a
newline. If I put in my control file
"terminated by '\n' " or "terminated by "\n" "
the loader complains, "expected quoted character, found "\n".
Because I want to stay compatible with other systems, I prefer not to use the "ENCLOSED BY " option.
Apparently Oracle objects to the fact that, as it parses, it thinks \n is 2 characters. Oracle supples "WHITESPACE" as a possible delimitor. Does it also have something like "NEWLINE"? Received on Tue Jul 13 1993 - 10:56:35 CEST