RE: constraints in create table..

From: Christopher Spence <cspence_at_FuelSpot.com>
Date: Thu, 30 Aug 2001 05:57:17 -0700
Message-ID: <F001.0037CCF6.20010830060314@fatcity.com>

Try
inserting into it, you will not be able to insert anything. <FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2>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 <FONT

face="Comic Sans MS" size=2>Oracle DBA <FONT face="Comic Sans MS" 
size=2>Phone: (978) 322-5744 <FONT face="Comic Sans MS" 
size=2>Fax:    (707) 885-2275 

Fuelspot <FONT

face="Comic Sans MS" size=2>73 Princeton Street <FONT 
face="Comic Sans MS" size=2>North, Chelmsford 01863 <FONT 
face="Comic Sans MS" size=2>  

  

  <FONT
  face=Tahoma size=2>-----Original Message-----From: Saurabh Sharma   [mailto:ssharma1_at_fcsltd.com] Sent: Wednesday, August 29, 2001 2:31   PMTo: Multiple recipients of list ORACLE-LSubject:   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 Received on Thu Aug 30 2001 - 07:57:17 CDT