Chk if this would suit.

SQL> create table my_tab (empno number , f1 number(1) default 1 not
null);

Table created.

SQL> insert into my_tab values(100,default);

1 row created.

SQL> select * from my_tab;

EMPNO F1
---------- ----------
100 1

SQL> alter table my_tab modify f1 number(1) default null;

Table altered.

SQL> insert into my_tab values(100,default);
insert into my_tab values(100,default)
*
ERROR at line 1:
ORA-01400: cannot insert NULL into ("MESALEDEV"."MY_TAB"."F1")


SQL> insert into my_tab values(100,2);

1 row created.

SQL> select * from my_tab;

EMPNO F1
---------- ----------
100 1
100 2

HTH
GovindanK

SQL>
<-----Original Message----->
From: Olga Gurevich
Sent: 10/30/2003 9:49:29 AM
To: [Email Address Removed] Re: how to get rid of default

Hi.

I have created a field in a table with a default
clause. - f1 number(1) not null default 1. How can I
get rid of the default now?

thanks

Gene



_______________________________________________________________
Get Your 10MB account for FREE at http://mail.arabia.com !
Access MILLIONS of JOBS NOW!
<http://ads.arabia.com/?SHT=text_email_english>
Oracle LazyDBA home page