Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Apparently, an error (or another Oracle puzzle a-la Daniel)
I'm guessing the column is not null novalidate.
wizofoz2k_at_yahoo.com.au (Noons) wrote in message news:<73e20c6c.0402260223.71c5c301_at_posting.google.com>...
> 9ir2, SQL*Puss:
>
> Purr>desc zot
> Name Null? Type
> ----------------------------------------------------- --------
> -------------- F1
> NUMBER
> F2
> VARCHAR2(20)
> F3 DATE
>
> Purr>alter table zot modify (f1 not null);
> alter table zot modify (f1 not null)
> *
> ERROR at line 1:
> ORA-01442: column to be modified to NOT NULL is already NOT NULL
>
> Elapsed: 00:00:00.00
> Purr>desc zot
> Name Null? Type
> ----------------------------------------------------- --------
> -------------- F1
> NUMBER
> F2
> VARCHAR2(20)
> F3 DATE
>
>
> A virtual shot of single malt for the first correct solution.
> Hint: HJR discussed why, a while ago in a different context.
>
> Cheers
> Nuno Souto
> wizofoz2k_at_yahoo.com.au.nospam
Received on Thu Feb 26 2004 - 13:05:09 CST