Re: Can DATA type be NULL?

From: Gene Plagge <gplagge_at_hotmail.com>
Date: Mon, 2 Nov 1998 13:59:03 -1000
Message-ID: <F42CB9DBDC42D211B39F00AA00AF328201DB27D6@Keiki.Hpu.Edu>

Tal,
I successfully created the table and did the insert as you listed in your post.

What tool did you use to create the table? SQLPlus? Some other tool?

• Gene Plagge
• Successful table creation

SQL> create table TEST
  2 (id NUMBER,
  3* sampleDate DATE )
SQL> / Table created.

SQL> insert into test
  2 (id)
  3 VALUES (1); 1 row created.

---

Tal Golan wrote in message <363a7f5a.0_at_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 Mon Nov 02 1998 - 17:59:03 CST