Question: In Oracle, is there a way to remove the default of the column of a table ?
Hi,
In Oracle, I created a table with nn columns.
In one of the columns I defined a default value.
Now the default value is not valid anymore.
I would like to keep the column but remove the default.
Is there a way to remove the default of the column of a table ?
The following is an example of my question:
create table test (
t1 number,
t2 number default 0
) ;
insert into test(t1,t2) values (1,1);
insert into test(t1) values (2);
-- The following does not work to remove the default
alter table test modify (
t2 number) ;
insert into test(t1) values (3);
Any ideas besides dropping and recreating the column ?