Re: SQL/Plus: script-problems

From: Olaf van der Geest <ogeest_at_nl.oracle.com>
Date: Sat, 2 Jul 1994 22:50:00 GMT
Message-ID: <CsC4rD.F5K_at_nl.oracle.com>


Thomas Gsuck (gsuck_at_rvs.uni-hannover.de) wrote:
: Hi !
: I have a problem concerning a small sql-script.
: CREATE TABLE kat.nup
: (id number(4),
 ...
: bem3 VARCHAR2(255),
: CONSTRAINT const_nup
: PRIMARY KEY (id)
: ***>>>! FOREIGN KEY (kabel) REFERENCES kat.kabel(nummer) ....

Thomas,

Looks like you missed a comma, after the primary key definition.
: CONSTRAINT const_nup
: PRIMARY KEY (id), <-------
: FOREIGN KEY (kabel) REFERENCES kat.kabel(nummer) ON DELETE CASCADE );

Cheers,

Olaf Received on Sun Jul 03 1994 - 00:50:00 CEST

Original text of this message