What is wrong with this SQL Code?

Question

So I am writing this code and it keeps giving me the error: missing right parenthesis. Am I not finding it or something? I have other code that looks like this and worked, but for some reason, this is not wanting to go through. It says it is happening around line 2 of my code....

SQL Code:

CREATE TABLE MOVIES
(title_id NUMBER (10) NOT NULL UNIQUE,
title VARCHAR2 (60) NOT NULL,
description VARCHAR2 (400) NOT NULL,
rating VARCHAR2 (4) CHECK (rating= 'G','PG','PG13','R'),
category VARCHAR2 (20) CHECK (category= 'DRAMA','COMEDY','ACTION','CHILD','SCIFI','DOCUMENTARY'),
release_date NOT NULL),
PRIMARY KEY (title_id));

This is not MySQL syntax. Trying to convert from another DB engine? — juergen d
– juergen d, Commented Dec 8, 2016 at 6:21
Not sure what you are telling me. I am new to all of this. I put this code into ORACLE database to create the table and it's not wanting to create because of a right parenthesis apparently missing. — Heyhey
– Heyhey, Commented Dec 8, 2016 at 6:24
I see. I replaced the MySQL DB tag with Oracle in your question — juergen d
– juergen d, Commented Dec 8, 2016 at 6:25

igr · Accepted Answer · 2016-12-09 15:36:36Z

1

There are couple of mistakes in your code.

unwanted parenthesis after release_date column and a missing datatype
For checking list of values you have used = but you need to use IN

Try this

CREATE TABLE MOVIES
  (
     title_id     NUMBER (10) NOT NULL, -- unique key will be overridden by the Primary key 
     title        VARCHAR2 (60) NOT NULL,
     description  VARCHAR2 (400) NOT NULL,
     rating       VARCHAR2 (4) CHECK (rating IN ( 'G', 'PG', 'PG13', 'R')), -- Should be IN instead of = 
     category     VARCHAR2 (20) CHECK (category IN ( 'DRAMA', 'COMEDY', 'ACTION', 'CHILD', 'SCIFI', 'DOCUMENTARY')), -- Should be IN instead of = 
     release_date timestamp NOT NULL, -- Unwanted close parenthesis and missing datatype
     PRIMARY KEY (title_id)
  );

edited Dec 9, 2016 at 15:36

igr

3,5091 gold badge22 silver badges25 bronze badges

answered Dec 8, 2016 at 6:25

Pரதீப்

94.1k21 gold badges144 silver badges179 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

igr Over a year ago

release_date has no type

Pரதீப் Over a year ago

@igr - yeah missed it

igr Over a year ago

Maybe date or timestamp, datetime is not an Oracle column type

Heyhey Over a year ago

Thanks both of you! Sorry I am new to all of this and surprised I didn't have more mistakes than I did! Thanks again. :)

igr Over a year ago

UNIQUE on title_id is superfluos, as it is covered by primary key

|

Collectives™ on Stack Overflow

What is wrong with this SQL Code?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related