-
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 ?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|