Null in a Number Field

[jeepxo]

In MS SQL I can define a column as a numeric and still use "null" as a value.

Is there a way to do this in Oracle? From what I have seen from the NUMBER data type I have to put a numeric value in and can't use a null

To build may have to be the slow laborious task of years. To destroy can simply be the thoughtless act of a single day.

 

[Turkbear]

Hi,
As long as the NOT NULL constraint is not on the field, NULL should be a valid value...


Can you post the results of a DESC TABLENAME ?







To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[Thargy]

Also, just as in SQL Server, the table may have been defined as allowing nulls, but a separate constraint may have been added after the table was created. Don't forget to check that there isn't a user constraint lurking somewhere in the undergrowth.....

Regards

T

 

[SantaMufasa]

...And as a proof of concept for what Turkbear and Tharg are saying:

SQL> create table jeepxo (x number);

Table created.

SQL> insert into jeepxo values (null);

1 row created.

SQL> insert into jeepxo values (1);

1 row created.

SQL> select * from jeepxo;

         X
----------

         1

2 rows selected.

Notice 2 rows selected, of which one row's value is NULL.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]
“Beware of those that seek to protect you from harm or risk. The cost will be your freedoms and your liberty.”