Can DATA type be NULL?

From: Tal Golan <talgolan_at_optic-nerve.com>
Date: Fri, 30 Oct 1998 19:13:28 -0800
Message-ID: <363a7f5a.0@newsread.exodus.net>

This seems like a stupid questions, but...

I have created a table that includes a 2 columns:

create table TEST (

id                   NUMBER

sampleDate DATE

);

the following sql produces an error:

insert into test
(id)

VALUES
(1);

ORA-01400: cannot insert NULL into ("WWW"."TEST"."SAMPLEDATE")

Any help would be greatly appreciated.

Thanks.

Tal Golan
talgolan_at_optic-nerve.com Received on Fri Oct 30 1998 - 21:13:28 CST