Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to set a column not using default value

Re: How to set a column not using default value

From: Dmitry E. Loginov <dmitry_loginov_at_mtu.ru>
Date: Mon, 3 Dec 2001 22:50:21 +0300
Message-ID: <9ugm3j$nhn$1@gavrilo.mtu.ru>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US