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: Apparently, an error (or another Oracle puzzle a-la Daniel)

Re: Apparently, an error (or another Oracle puzzle a-la Daniel)

From: boocal <eoin_gardiner_at_msn.com>
Date: 26 Feb 2004 11:05:09 -0800
Message-ID: <882e45e9.0402261105.279c6d7@posting.google.com>


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

Original text of this message

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