Dear all,
how do I change the column default value from NOT NULL to NULL?
Suppose I run the following commands:
SQL> alter table hr.test modify temp_num2 default null;
Table altered.
SQL> desc hr.test;
Name Null? Type
----------------------------------------- -------- ----------------------------
TEMP_NUM NUMBER
TEMP_NUM2 NOT NULL NUMBER
Why didn't temp_num2 constraint change to NULL? I'm running 11.g rel2
Best regards,
Valerie