Could somone exceptionally bright take alook at this code and suggest
why the default values are not being inserted?
CREATE TABLE CUSTOMER
( CUSTOMER_ID NUMBER(4)
NOT NULL
CONSTRAINT gaz PRIMARY KEY,
TITLE CHAR(4)
DEFAULT 'mr' <---------- this isnt working???
CONSTRAINT gaz2
NOT NULL
CHECK(title in('mr','miss','mrs')) ,
SURNAME CHAR(20)
CONSTRAINT gaz3
NOT NULL
CHECK(surname = UPPER(surname)),
FORENAME CHAR(20)
CONSTRAINT gaz4
NOT NULL
CHECK(forename = UPPER(forename)))
TABLESPACE "USERS";
Any idea?
Received on Tue Nov 05 2002 - 19:29:51 CST
