This discussion is archived
2 Replies Latest reply: Jun 19, 2013 1:48 AM by hydra63125 RSS

Missing right parenthesis sql plus

1004689 Newbie
Currently Being Moderated
Hi, trying to create this table but *'Missing right parenthesis'* on the 16th line, which starts FOREIGN KEY comes up, I don't know where I'm going wrong. Help PLEASE!


CREATE TABLE player_performance
(
player_performance_id numeric(10)NOT NULL,
player_id numeric(10) NOT NULL,
match_id numeric(10) NOT NULL,
two_points_attempts integer,
two_points_made integer,
three_points_attempts integer,
three_points_made integer,
free_throw_attempts integer,
free_throws_made integer,
minutes_played integer,
fouls_made integer,
rebounds integer,
CONSTRAINT player_performance_PK PRIMARY KEY (player_performance_id)
FOREIGN KEY (player_id) REFERENCES player (player_id);
);

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points