Executing Auto Increment Query

Question

CREATE TABLE Persons
(
ID int NOT NULL AUTO_INCREMENT,
LastName varchar(255) NOT NULL,
FirstName varchar(255),
Address varchar(255),
City varchar(255),
PRIMARY KEY (ID)
)

Error starting at line 1 in command: CREATE TABLE Persons ( ID int NOT NULL AUTO_INCREMENT, LastName varchar(255) NOT NULL, FirstName varchar(255), Address varchar(255), City varchar(255), PRIMARY KEY (ID) ) Error at Command Line:3 Column:17 Error report: SQL Error: ORA-00907: missing right parenthesis 00907. 00000 - "missing right parenthesis" *Cause: *Action:

I would like to know if there is any other alternative. I tried with checking out if in the UI i had any feature to add the auto increment condition. But, i was unable to find one — Suresh, Jan 29 '15 at 07:04
If its Oracle, try this: http://stackoverflow.com/questions/11296361/how-to-create-id-with-auto-increment-on-oracle — Tobi, Jan 29 '15 at 07:05
Still the same.. and it doesn't matter about semicolon if its a single query right? — Suresh, Jan 29 '15 at 07:06
In Oracle12 you can use an identity column: https://docs.oracle.com/database/121/SQLRF/statements_7002.htm#SQLRF01402 — a_horse_with_no_name, Jan 29 '15 at 07:28

score 0 · Accepted Answer · edited May 23 '17 at 10:26

0

In Oracle, there is no AUTO_INCREMENT. Try the solution in this link to trigger an auto increment:

edited May 23 '17 at 10:26

Community

1
1

answered Jan 29 '15 at 07:07

Tobi

1,442
1
13
26

Executing Auto Increment Query

1 Answers1