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
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,
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
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