Re: How to load a complete empty record using sqlldr?
From: Joaquin Garcia Santos <jis_at_iberdrolaingenieria.es>
Date: Thu, 10 Jun 1999 08:54:50 +0200
Message-ID: <7jnmtt$m3v$1_at_talia.mad.ttd.net>
Date: Thu, 10 Jun 1999 08:54:50 +0200
Message-ID: <7jnmtt$m3v$1_at_talia.mad.ttd.net>
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 - 08:54:50 CEST