"alter table APP modify APP_STATUS varchar2(10)" doesn' t change default
values in column definition.
Thanks again!
"Steve @ CloudSpace" <steve_at_cloudspace.com> wrote in message
news:5aTO7.190309$zK1.50211115_at_typhoon.tampabay.rr.com...
> did you mean the default values of existing records? "alter table APP
modify
> APP_STATUS varchar2(10)" will disable the DEFAULT for future insertions.
and
> that won't delete those that are already in the table. you will need to
use
> "update table_name set..." to change them.
> hope this helps!
> --
> Steve - CloudSpace New Media
> steve_at_cloudspace.com
> http://www.cloudspace.com
> "Jenny" <jennyw_at_housing.tamu.edu> wrote in message
> news:9ugouj$6qv$1_at_news.tamu.edu...
> > "alter table APP modify APP_STATUS varchar2(10)" didn't get rid of
default
> > value. Thanks anyway!
> >
> > Jenny
> >
> >
> > "Steve @ CloudSpace" <steve_at_cloudspace.com> wrote in message
> > news:nbRO7.187213$zK1.50074524_at_typhoon.tampabay.rr.com...
> > > well, if "alter table APP modify APP_STATUS varchar2(10) default NULL"
> > > doesn't work, then "alter table APP modify APP_STATUS varchar2(10)"
> would
> > do
> > > it.
> > >
> > > --
> > > Steve - CloudSpace New Media
> > > steve_at_cloudspace.com
> > > http://www.cloudspace.com
> > > "Jenny" <jennyw_at_housing.tamu.edu> wrote in message
> > > news:9ugkfh$17e$1_at_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 Tue Dec 04 2001 - 11:45:27 CST
