Re: How to set a column not using default value

From: fred <anon_at_spain.es>
Date: Mon, 03 Dec 2001 17:58:58 +0000
Message-ID: <3C0BBD62.8F6C84AC@spain.es>

Try:
alter table APP modify APP_STATUS default NULL

Anthony Hogan
hogananthony_at_hotmail.com

Jenny wrote:
>
> I have a column VARCHAR2(10) with default value set to 'W'. Now I need to
> set it not using default. I tried to delete the default value in DBA Studio,
> I got "missing expression" message. I also tried sql statement "alter table
> APP modify APP_STATUS default", I got same message "missing expression".
> (I'm using Oracle 8.1.5. running on NT machine.) Thanks in advance!
>
> Jenny
> jennyw_at_housing.tamu.edu
Received on Mon Dec 03 2001 - 11:58:58 CST