Skip to content
Advertisement

I am getting “missing keyword” error in oracle sql

I am new to SQL and I am trying to create the table for itinerary items however keep getting the same error message that I am “missing a keyword”. I have tried looking it up for what is wrong however I can not find anything

Any solution or if you have any design suggestions to this would be much appreciated!

create table itinerary_item
( tour_id     varchar(8) 
, location_id varchar(8) 
, order_visited_number varchar(8) 
, primary key (tour_id, location_id) 
, foreign key (tour_id) references tour(tour_id)
, foreign key (location_id) location(location_id)
);

Advertisement

Answer

Hi please use references keyword at the last line of your sql table creation script!!!

User contributions licensed under: CC BY-SA
9 People found this is helpful
Advertisement