default a column

[marist89]

Originally posted by Mr.Hanky
I'm pretty sure that if you do not specify not null it will only affect future inserts. Try it out. Insert into that table but leave the col null.

MH

Not true:

SQL> select * from xyz;

         X
----------
         1
         2

SQL> alter table xyz add (y number(10) default 0);

Table altered.

SQL> select * from xyz;

         X          Y
---------- ----------
         1          0
         2          0