Re: Loading BLANKS into DATE field

The problem is that BLANKS is not a valid date. It looks like the real problem
record is
couple things. First, you can rethink the NOT NULL not how your application works, it should not be how your Secondly, you could pick some default high or low valid date to use as the default when no value is available (e.g birthdate = 01/01/1800). This is less
saves you
Olcott, President
<352C587C.7215A276_at_domain.com>,

wrote:
text/plain; charset=us-ascii
have a table with so many fields of different data types. fields is bdat (Birth date)., Its definition in table is NULL
field
the
tell me a way to load BLANKS in DATE field ? >
charset=us-ascii
<BR>I have a table with so many fields of different data types.
these fields is bdat (Birth date)., Its&nbsp; definition in
<BR>&nbsp;<B> bdat&nbsp; DATE&nbsp;&nbsp; NOT&nbsp; NULL</B><B></B>
<P>As a default value for some records I have to store BLANKS in this field
<BR>But when I am trying to load this with SQL*Loader it is rejecting the
records
tell me a way to load BLANKS in DATE field ?
<BR>Suresh

>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Thu Apr 09 1998 - 08:19:20 CDT