Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> constraints in create table..

constraints in create table..

From: Saurabh Sharma <ssharma1_at_fcsltd.com>
Date: Wed, 29 Aug 2001 11:00:13 -0700
Message-ID: <F001.0037B8DC.20010829103058@fatcity.com>

hi all,
 

do anybody explain me what is
happening when i'm creating a table with the following constraints..
 

CREATE TABLE
TAB1(
ENUM NUMBER PRIMARY KEY
CHECK(ENUM IS NULL),
ENAME
VARCHAR2(10)
);
 

why i'm being able to create
table with such contradicting constraints. both can't be true at the
same time.
i can't have null in aprimary
key.
 

what's the significance of
this DDL.
 

thanks in
advance..
 

Saurabh
Sharma Received on Wed Aug 29 2001 - 13:00:13 CDT

Original text of this message

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