Member Avatar for C

Hi,

If I could please get some help? I have missed the lectures on creating tables due to my daughter being sick. I am trying to follow the lecture notes but I am having issues. I get the following error

Error at Command Line : 4 Column : 21
Error report -
SQL Error: ORA-00907: missing right parenthesis
00907. 00000 -  "missing right parenthesis"
`*Cause:
*Action:




CREATE TABLE Film
(
film_code number(5)PRIMARY KEY,
title varchar2 (200)FOREIGN KEY,
running_time number(3,2) NOT NULL, 
classification varchar2(200),
);

Any help would be welcome.

Thanks in advance.

  • 2 Contributors
  • 2 Replies
  • 1K Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by C
Member Avatar for urtrivedi

remove , before );

CREATE TABLE Film
(
film_code number(5)PRIMARY KEY,
title varchar2 (200)FOREIGN KEY,
running_time number(3,2) NOT NULL, 
classification varchar2(200)
);
Member Avatar for C

Thank you for your help. I found out the film table didn't need a foregin key after all. I have a lot to learn.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.