Andrew
Member
Registered: 5th May 04
Location: Skoda Octavia Estate, Ford Puma
User status: Offline
|
I'm trying to create a Foreign Key. Code i've done: -
CREATE TABLE Advanced_Flight_Information
(Flight_Identifier CHAR(5) FOREIGN KEY,
Departure_City CHAR(10) NOT NULL,
Departure_Country CHAR(10) NOT NULL,
Departure_Runways CHAR(10) NOT NULL,
Stopover CHAR(10) NOT NULL,
Destination_City CHAR(10) NOT NULL,
Destination_Country CHAR(10) NOT NULL,
Destination_Runways CHAR(10) NOT NULL);
Error: -
ERROR at line 2:
ORA-00907: missing right parenthesis
|
