http://asktom.oracle.com/pls/ask/f?p=4950:8:1537558593675236852::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:263015358908,
Cheers,
Dave
Nuno Souto wrote:
> create table zot(
> f1 number default 0,
> f2 date);
> .
> .
> .
> Kewl!
> Now, I want to remove the "DEFAULT 0"
> from the table.
> .
> .
> .
> alter table zot modify(f1 ......<wth?>);
> .
> .
> .
> <don't tell me the darn thing is a hidden
> contraint!>
>
> TIA for any help.
> Cheers
> Nuno Souto
> wizofoz2k_at_yahoo.com.au.nospam
>
> PS: Of course, all usual avenues of doco have been
> exhausted b4 coming here. 8ir3, same in 9ir2.
Received on Thu Jul 31 2003 - 20:31:37 CDT
