Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQL Loader question
I am a beginner of using SQL loader. I have a problem in using loader.
I have a control file as follows:
load data
infile *
append
into table testing
fields terminated by ',' optionally enclosed by '"'
(id,b,c)
begindata
1,null,'c'
2,3,'c'
..
Loading has error due to the NULL value. How can I handle the NULL value in the control file? Moreover, how can I handle the NULL value if the NULL value appears at the end of the line?
Thanks,
David
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sat Oct 30 1999 - 14:10:34 CDT