Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL-Loader-Problem

SQL-Loader-Problem

From: <christian.guenther_at_mch.sbs.de>
Date: 1998/01/26
Message-ID: <34cc6869.14075759@news>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US