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

Home -> Community -> Usenet -> c.d.o.server -> Re: How to remove a default value from a column

Re: How to remove a default value from a column

From: QuestionExchange <USENET_at_questionexchange.com>
Date: 11 Oct 1999 13:04:03 GMT
Message-ID: <1430qx@questionexchange.com>


Try - Alter tabe taba modify col1 default null; Seems to me that is all it takes!
Becca
> Probably a simple one;
>
> Does anybody know how to remove a default value from a
column?
>
> Thanks in advance, Jean-Luc
>
>
>
>
>
>

--
  This answer is courtesy of QuestionExchange.com   http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=4477&cus_id=USENET&qtn_id=3647 Received on Mon Oct 11 1999 - 08:04:03 CDT

Original text of this message

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