Re: Oracle not null error when using datatype int

On 25 Nov 2002, rdalfonso_at_nyc.rr.com wrote:
> I get an error when I use a database column of datatype 'int'
> or 'number'

I don't get your results:

    SQL> create table t1 (id number);

    Table created.

    SQL> insert into t1 values (NULL);

    1 row created.

    SQL> create table t2 (id int);

    Table created.

    SQL> insert into t2 values (NULL);

    1 row created.

> that has constraint NOT NULL.

Of course you won't be allowed to insert NULL into a NOT NULL field.

-- 
Galen Boyer