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 drop a default value for a column

How to drop a default value for a column

From: Kalle <kalle_at_nospam.com>
Date: Tue, 29 Nov 2005 06:38:07 GMT
Message-ID: <jHSif.15880$_k2.266569@news2.nokia.com> 





Hi all,



I have a table



xxx



col1    varchar2(10)    default 'x'    null,
col2    varchar2((100)    not null


/



now I would like to drop the default value for col1



How to do it?



rgds


Kalle 
Received on Tue Nov 29 2005 - 00:38:07 CST












Original text of this message













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