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 -> SQL*Plus - PK Question

SQL*Plus - PK Question

From: Sted Alana <Sted_Alana_at_hotmail.com>
Date: Tue, 23 Apr 2002 07:02:14 GMT
Message-ID: <3cc506ff_1@news.iprimus.com.au>


I have come across many examples in sql*plus with regards to using 'not nulls' in conjunction with primarys keys. This bothers me because from my reading when a primary key is defined for an attributes(s) of a table, it assumes that those values cannot contain null values, but yet i see this:

create table Example
(

    sid char(5) not null,
    ....
    constraint pk_sid primary key (sid)
);

why need to use not null when primary key implicitly imposes that contraint?

Any help appreciated. Received on Tue Apr 23 2002 - 02:02:14 CDT

Original text of this message

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