0
create table user
(
id number(10) auto_increment,
firstName varchar(100),
lastName varchar(100),
password varchar(100),
primary key(id)
);

I am getting this error while creating table user

Abhishek
  • 9
  • 1
  • Possible duplicate of [How to create id with AUTO\_INCREMENT on Oracle?](http://stackoverflow.com/questions/11296361/how-to-create-id-with-auto-increment-on-oracle) – Alex Poole Jun 24 '16 at 17:49
  • 1
    Oracle doesn't support auto_increment (until 12c anyway), and your primary key creation syntax is wrong too. [See this](http://stackoverflow.com/q/11296361/266304). – Alex Poole Jun 24 '16 at 17:50

0 Answers0