Re: How to set a column not using default value

From: Jenny <jennyw_at_housing.tamu.edu>
Date: Mon, 3 Dec 2001 13:49:47 -0600
Message-ID: <9ugkfh$17e$1@news.tamu.edu>

Statement "alter table APP modify APP_STATUS default NULL" sets default to NULL. That is different from no default value. Thanks anyway!

Jenny

"fred" <anon_at_spain.es> wrote in message news:3C0BBD62.8F6C84AC_at_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 - 13:49:47 CST