How to load a complete empty record using sqlldr?

From: <ewong74_at_netscape.net>
Date: Wed, 09 Jun 1999 22:36:27 GMT
Message-ID: <7jmq9a$126$1@nnrp1.deja.com>

Hi there,

I have a ascii data file(separated by |) with 2 fields and thousands of rows. One of the rows(the first row) is completely empty. The data file looks like:

aaa|bbb
ccc|ddd
eee|fff

If I do a load using sqlldr, the first record(the one completely empty) are always discarded. Is there a way to load a completely empty row using sqlldr? You may ask why I need to load a empty record into the db. This is for some data relationship purpose that I must do. And I don't want to do a insert ... values ('','') every time after the db is refreshed.

Thanks!

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jun 09 1999 - 17:36:27 CDT