|
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
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
| 