Re: The NULL in Oracle 7.3
Date: Wed, 01 Aug 2001 09:01:19 -0500
Message-ID: <rp2gmt8ev85er2i06jcl3o56cpq6nnho49_at_4ax.com>
Yep...( My brain hurts !!) -
I misspoke, when a date field is defined as such, it is BLANKS that cannot be loaded or inserted into them, you need to use
NULL ( hence, the NULLIF BLANKS clause in SqlLdr)
sorry,
"Matt B." <gtimatt_at_home.com> wrote:
>"TurkBear" <noone_at_nowhere.com> wrote in message
>news:ssldmt40mm40897o4nakh77cf6g35e0n0t_at_4ax.com...
>>DATE fields must be BLANK if no date entered, not NULL
>
>??? I've set DATE columns to NULL (not ' ' or '') and have used IS NULL and IS
>NOT NULL on DATE columns lots of times.
>
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Wed Aug 01 2001 - 16:01:19 CEST