Re: How to set a column not using default value

Have you tried alter table APP modify APP_STATUS nodefault

Jenny wrote:

> 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