Re: SQL*Loader default field value
From: Dan Casey <dancasey_at_ix.netcom.com>
Date: Thu, 30 Apr 1998 23:32:09 -0700
Message-ID: <6ibqer$auk_at_sjx-ixn4.ix.netcom.com>
Date: Thu, 30 Apr 1998 23:32:09 -0700
Message-ID: <6ibqer$auk_at_sjx-ixn4.ix.netcom.com>
Use the key words PRESERVE BLANKS to maintain the blank field.
markjo_at_cwcinc.com wrote in message <6ia9j7$sr5$1_at_nnrp1.dejanews.com>...
>I have a table in an Oracle 8 database that has three fields that make up
the
>primary key. I am loading it with the following control file:
>
.. .. ..
>There was a reply to another message about using :nvl(my field name, ' ')
in
>the field description but I haven't found a syntax it likes.
>
>Any help would be greatly appreciated.
>
>Thanks in advance.
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri May 01 1998 - 08:32:09 CEST