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: Kalmact <kalmact_at_hotmail.com>
Date: 26 Feb 2004 09:57:23 -0800
Message-ID: <8007e332.0402260957.293a0235@posting.google.com>


I got it :-)

create table test_1 (test number);

Table created.

desc test_1

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TEST                                               NUMBER

alter table test_1 modify test not null novalidate;

Table altered.

desc test_1

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TEST                                               NUMBER

alter table test_1 modify test not null; alter table test_1 modify test not null

                          *

ERROR at line 1:
ORA-01442: column to be modified to NOT NULL is already NOT NULL

desc test_1

 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 TEST                                               NUMBER


Cheers,
Kal
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 - 11:57:23 CST

Original text of this message

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