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.