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 -> Not Null constraint

Not Null constraint

From: astalavista <spam_at_nowhere.com>
Date: Thu, 5 Jan 2006 21:23:24 +0100
Message-ID: <43bd803f$0$10604$626a14ce@news.free.fr>


Hi,

I have two databases 9.2.0.5 (AIX)
with exactly the same table dvordtm

Do you know why ?
Can you help me ?
Thanks in advance ....

SQL> create table toto
  2 as select dtdate from dvordtm where 1=0;

SQL> desc toto

 Nom                                       NULL ?   Type
 ----------------------------------------- -------- -------------------

 DTDATE                                    NOT NULL DATE

SQL> create table toto
  2 as select dtdate from dvordtm where 1=0;

SQL> desc toto

 Nom                                       NULL ?   Type
 ----------------------------------------- -------- ---------------------

 DTDATE                                             DATE


SQL> desc dvordtm
 Nom                                       NULL ?   Type
 ----------------------------------------- -------- ---------------------

 DTDATE                                    NOT NULL DATE
 PERCPT                                             VARCHAR2(6)
 ACNTYY                                             VARCHAR2(4)
 ACNTMM                                             VARCHAR2(2)
 CDCLOSEDAY                                NOT NULL VARCHAR2(1)
 FLAG_LAST_CLOSED_PERIOD                   NOT NULL VARCHAR2(1)
 FLAG_LAST_CLOSED_YEAR                     NOT NULL VARCHAR2(1)
 FLAG_ACTUAL_PERIOD                        NOT NULL VARCHAR2(1)
 FLAG_ACTUAL_YEAR                          NOT NULL VARCHAR2(1)
 FLAG_PREVIOUS_CLOSED_PERIOD               NOT NULL VARCHAR2(1)
 FLAG_PREVIOUS_CLOSED_YEAR                 NOT NULL VARCHAR2(1)
 FLAG_PREVIOUS_PERIOD                      NOT NULL VARCHAR2(1)
 FLAG_PREVIOUS_YEAR                        NOT NULL VARCHAR2(1)
 CALENDAR_YEAR                             NOT NULL VARCHAR2(4)
 CALENDAR_WEEK                             NOT NULL VARCHAR2(2)
Received on Thu Jan 05 2006 - 14:23:24 CST

Original text of this message

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