alter table t
modify first_name varchar2(20);
[\code]
doesn't work... the default still exists. You can do a couple of things that will have the effect of removing the default:
[code]
alter table t
modify first_name varchar2 default '';
or
alter table t
modify first_name varchar2 default NULL;
[\code]