Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to load a complete empty record using sqlldr?
Use Trailing nullcols. Look at an example:
LOAD DATA
INFILE PLAN.TXT
APPEND
INTO TABLE P
FIELDS TERMINATED BY '#'
TRAILING NULLCOLS
(P, DESCRIPTION, DATE_PLAN, IOBJ)
Received on Thu Jun 10 1999 - 01:54:50 CDT