Error Creating Table "Missing Right Parenthesis"

Question

I keep being told I am missing a right parenthesis but I'm not seeing it, can anybody point it out?

CREATE TABLE Member
( MEMBER_ID int NOT NULL AUTO_INCREMENT
, FIRST_NAME varchar(255) NOT NULL
, LAST_NAME varchar(255) NOT NULL
, STREET_ADDRESS varchar(255) NOT NULL
, CITY varchar(255) NOT NULL
, STATE varchar(2) NOT NULL
, ZIPCODE int NOT NULL
, PRIMARY KEY(MEMBER_ID)
);

Can you give the exact error message? And is this the ONLY command that you're running? — Jazzepi, Apr 10 '13 at 18:45
Works copied and pasted as-is for me... odd. Is this the SQL statement as-is or is there code or variables being used? — Wing Tang Wong, Apr 10 '13 at 18:45
@Jazzepi that's seriously the error message it gives me, no line reference or anything. I'm using APEX so it's just: "Missing Right Parenthesis" — Howdy_McGee, Apr 10 '13 at 18:51
Oracle apparently does not have AUTO_INCREMENT columns. See http://stackoverflow.com/questions/8116209/auto-increment-column-differences-in-sql-syntax-between-oracle-and-mysql for work-arounds. — PM 77-1, Apr 10 '13 at 18:54
@WingTangWong - Did the statement work for you in **Oracle**? — PM 77-1, Apr 10 '13 at 18:55

score 6 · Accepted Answer · edited May 23 '17 at 11:43

6

There's no such thing as AUTO_INCREMENT in oracle.

Take a look at This Question. It's likely this that is giving you the error.

edited May 23 '17 at 11:43

Community

1
1

answered Apr 10 '13 at 18:45

N West

6,768
25
40

1

Crap... Auto_Increment is MYSQL >.> – Howdy_McGee Apr 10 '13 at 18:49

Error Creating Table "Missing Right Parenthesis"

1 Answers1