"Thomas Wagner" <twapriv-nospam_at_yahoo.com> wrote in message
news:3a07da7d.0402260900.fc0f62b_at_posting.google.com...
> SQL>alter table x enable constraint c1;
>
> Table altered.
>
> SQL>desc x
> Name Null? Type
> ----------------------------------------- -------- --------------------------
--
> N1 NOT NULL NUMBER
> N2 NUMBER
Yup, you got it. Which brand of single malt? :)
Funny one, eh? I don't think this happens with older versions
as NOT NULL was not rally handled as a constraint.
With 9i it happens as expected of any constraint, it's just
that describe doesn't tell us the full story.
--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
Received on Fri Feb 27 2004 - 08:30:17 CST
