Re: Can DATA type be NULL?

From: <nasof_at_hotmail.com>
Date: Sat, 31 Oct 1998 14:48:56 GMT
Message-ID: <71f80q$65u$1@nnrp1.dejanews.com>

I would be willing to bet that you created the table through some tool, and it put a "NOT NULL" constraint on it. I can't see any other reason for this behavior.

-Frank

In article <363a7f5a.0_at_newsread.exodus.net>, "Tal Golan" <talgolan_at_optic-nerve.com> wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Oct 31 1998 - 08:48:56 CST