Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Loading BLANKS into DATE field

Loading BLANKS into DATE field

From: T Suresh kumar <defaultuser_at_domain.com>
Date: Thu, 09 Apr 1998 10:41:24 +0530
Message-ID: <352C587C.7215A276@domain.com>


Hello
I have a table with so many fields of different data types. One of these fields is bdat (Birth date)., Its definition in table is   bdat DATE NOT NULL

As a default value for some records I have to store BLANKS in this field

But when I am trying to load this with SQL*Loader it is rejecting the records
where BLANKS are specified for DATE field.

Can any one tell me a way to load BLANKS in DATE field ?

Thanks in advance
Suresh Received on Thu Apr 09 1998 - 00:11:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US