create table error [message #10199] |
Thu, 08 January 2004 07:48 |
antreas
Messages: 5 Registered: January 2004
|
Junior Member |
|
|
I run in sqlplus the following:
CREATE TABLE OWNER
(ID CHAR(7) NOT NULL,
NAME CHAR(10) NOT NULL,
SURNAME CHAR(10) NOT NULL,
TOWN CHAR(10) NOT NULL,
PRIMARY KEY(ID));
CREATE TABLE OWNERSHIP
(ID CHAR(7) NOT NULL,
LICENCE CHAR(10) NOT NULL,
DEGREE INT,
PRIMARY KEY(ID),
FOREIGN KEY(ID) REFERENCES OWNER(ID)
ON DELETE SET NULL ON UPDATE CASCADE);
and i get a "error right parenthesis missing" in the last line.Anyone has any idea about what is wrong?
Any feedback would be appreciated.
|
|
|
|
|