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

From: Noons <wizofoz2k_at_yahoo.com.au>
Date: 26 Feb 2004 02:23:15 -0800
Message-ID: <73e20c6c.0402260223.71c5c301@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 - 04:23:15 CST