Re: How to set a column not using default value

"alter table APP modify APP_STATUS nodefault" gave error message "invalid alteration of datatype".
"alter table APP modify APP_STATUS varchar2(10) nodefault" and "alter table APP modify APP_STATUS varchar2(10) no default" gave error message "invalid alter table option".

Thanks anyway!

Jenny

"Roger Stapley" <roger.stapley_at_oracle.com> wrote in message news:3C0CA8FB.3B5FD280_at_oracle.com...
> 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
>
Received on Tue Dec 04 2001 - 11:52:18 CST