RE: how to get rid of default

2003-10-30 Thread Khedr, Waleed
default null -Original Message- Sent: Thursday, October 30, 2003 12:50 PM To: Multiple recipients of list ORACLE-L 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

RE: how to get rid of default

2003-10-30 Thread Tim Fleury
I believe your only option with the alter table command is to set it to null (which it can't be on an insert that doesn't provide a value since the column is set up as not null). ALTER TABLE table_name MODIFY (column_name DEFAULT NULL); -Original Message- Sent: Thursday, October 30,

Re: how to get rid of default

2003-10-30 Thread Vladimir Begun
Olga Gurevich wrote: 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? Oracle9i SQL Reference Release 2 (9.2) ALTER TABLE column_clauses add_column_clause If a column has a default value, then you can use the DEFAULT

RE: how to get rid of default - thanks!!

2003-10-30 Thread Olga Gurevich
Just to say thanks to all who replied- Waleed, Valdimir. Govidan. sorry if i missed anyone Gene --- Khedr, Waleed [EMAIL PROTECTED] wrote: default null -Original Message- Sent: Thursday, October 30, 2003 12:50 PM To: Multiple recipients of list ORACLE-L Hi. I have created a