Table creation problem

From: gamaz <gamaz_at_earthlink.net>
Date: Wed, 09 Oct 2002 19:31:14 GMT
Message-ID: <6u%o9.18387$lV3.1768324@newsread1.prod.itd.earthlink.net>

Hi,
I am trying to create a table where I want only the first two fields to be not null values(composite primary key). However, the third row which has a datatype 'number' is automatically getting NOT NULL constraint inspite of forcing null constraint in the table definition. Is there any way to stop this from happening?
Thanks in advance.

The script I am running is the following:

SQL> create table stock_price (

  2  SYMBOL                 VARCHAR2(5)  NOT NULL,
  3  CLOSE_DATE             DATE         NOT NULL,
  4  SEQ_NO                 NUMBER       NULL,
  5  OPEN                   NUMBER(8,4),
  6  HI                     NUMBER(8,4),
  7  LO                     NUMBER(8,4),
  8  CLOSE                  NUMBER(8,4),
  9  VOLUME                 NUMBER(12),

 10 CONSTRAINT STOCK_PK PRIMARY KEY(SYMBOL, SEQ_NO)  11 );

Table created.

SQL> desc stock_price;

 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------------
----
 SYMBOL                                    NOT NULL VARCHAR2(5)
 CLOSE_DATE                                NOT NULL DATE
 SEQ_NO                                    NOT NULL NUMBER
 OPEN                                               NUMBER(8,4)
 HI                                                 NUMBER(8,4)
 LO                                                 NUMBER(8,4)
 CLOSE                                              NUMBER(8,4)
 VOLUME                                             NUMBER(12)

SQL> Received on Wed Oct 09 2002 - 14:31:14 CDT