Auto sequence incrementer at database

Question

I'm new to programming, so need little help from you guys.

I created a simple registration from in HTML controlled by servlet using oracle. Whenever i submit my record, it gets stored perfectly in database, but I have assigned ID for every stored record which is not appearing to be increment in ascending order even after assigning primary key to ID.

Are you looking to auto generate id in database, or in your code? — Gaurava Agarwal, Jul 24 '16 at 09:38

score 1 · Answer 1 · edited May 23 '17 at 11:58

1

There is no short way to auto increment id in database itself. This post describes good way to do it in oracle.

How to create id with AUTO_INCREMENT on Oracle?

edited May 23 '17 at 11:58

Community

1
1

answered Jul 24 '16 at 08:00

Gaurava Agarwal

974
1
9
32

score 0 · Answer 2 · answered Jul 24 '16 at 07:55

0

Use a database sequence. And increment it by 1 every time you take a new value from that DB sequence.

answered Jul 24 '16 at 07:55

Rahul Vedpathak

1,346
3
16
30

Can you please in detail . – Kaushik Aug 07 '16 at 05:00

Auto sequence incrementer at database

2 Answers2