Jürg Schaufelberger wrote:
> Hello
>
> I want to remove a default value. I tried the following statement:
> alter table myTable
> modify(myColumn default null)
> The default value is now removed, but not the definition.
> Is there a other way to clear the old definition ?
> (Oracle 8.1.7)
> Thanks for your help !
>
> Jürg
Go to Morgan's Library at www.psoug.org
click on Tables
scroll down to where DEFAULT is in the left column in CAP letters.
There is a demo that shows you how to do it.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Jan 16 2006 - 16:12:12 CST
