Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL-Loader-Problem
Hello,
is there a possibility to say Sql-Loader to change a value, that is in
the INFILE a NULL-Value to another value, for example to a space??
I read the manual, but didn't find anything.
ANother prolem I have is, I trie to skip columns in a datafile.
My datafile looks like that:
field1;;field2;;field3;;field4....
The Field delimiter I use is ';'. I always have two semicolons,
because I save an excel-spreadsheet as csv(comma seperated
values)-file and in this excel spreadsheet, I have between two columns
with data always an empty column.
Is there anybody, who have an idea??
Received on Mon Jan 26 1998 - 00:00:00 CST