Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to set a column not using default value
Try
APP modify APP_STATUS default null;
"Jenny" <jennyw_at_housing.tamu.edu> wrote in message
news:9ugcce$ict$1_at_news.tamu.edu...
> 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:50:21 CST