Home » SQL & PL/SQL » SQL & PL/SQL » create table error
create table error [message #10199] Thu, 08 January 2004 07:48 Go to next message
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.
Re: create table error [message #10202 is a reply to message #10199] Thu, 08 January 2004 10:07 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Oracle does not support cascading update constraints.

Other options
Re: create table error [message #10214 is a reply to message #10202] Thu, 08 January 2004 19:21 Go to previous message
antreas
Messages: 5
Registered: January 2004
Junior Member
Thanks man you were most helpful.
Previous Topic: to_char help
Next Topic: urgent help
Goto Forum:
  


Current Time: Thu Mar 28 10:10:13 CDT 2024