Is their any other way of auto_increment in oracle other than sequence | Sololearn: Learn to code for FREE!
New course! Every coder should learn Generative AI!
Try a free lesson
+ 1

Is their any other way of auto_increment in oracle other than sequence

5th Sep 2016, 5:44 PM
Robin Tyagi
Robin Tyagi - avatar
2 Answers
0
Not in versions before Oracle 12 - you would need a sequence and a trigger. Oracle 12 introduces an IDENTITY column type to which will auto increment when now rows are added.
5th Sep 2016, 7:49 PM
Michael Skae
Michael Skae - avatar
0
you can use INCREMENT constraint
6th Sep 2016, 9:07 AM
sangamesh naikar
sangamesh naikar - avatar