Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Loading BLANKS into DATE field
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