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 -> How to set a column not using default value

How to set a column not using default value

From: Jenny <jennyw_at_housing.tamu.edu>
Date: Mon, 3 Dec 2001 11:31:36 -0600
Message-ID: <9ugcce$ict$1@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 - 11:31:36 CST












Original text of this message













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