SQL Loader question

From: <david_petit_at_yahoo.com>
Date: Sat, 30 Oct 1999 19:10:34 GMT
Message-ID: <7vffr9$uqp$1_at_nnrp1.deja.com>



  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
[Quoted] fields terminated by ',' optionally enclosed by '"' (id,b,c)
begindata
[Quoted] 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 - 21:10:34 CEST

Original text of this message