Title: Message
Try inserting into it, you will not be able to insert anything.
 
Although Oracle allows it, it will not let you put data in it. 
 
 
 

"Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes."

Christopher R. Spence
Oracle DBA
Phone: (978) 322-5744
Fax:    (707) 885-2275

Fuelspot
73 Princeton Street
North, Chelmsford 01863
 

-----Original Message-----
From: Saurabh Sharma [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 29, 2001 2:31 PM
To: Multiple recipients of list ORACLE-L
Subject: constraints in create table..

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

Reply via email to