Auto-incrementing sequence and stored procedure in Oracle

Auto-incrementing sequence and stored procedure in Oracle

Oracle does not have auto-increment columns. In this case, you must manually write a method or use a sequence or trigger.

Easy to use (personal habits)

1. create sequence salary_seq
2.
3. increment by 1 --- add several
4.
5. start with 1 -- count from 1
6.
7. nonmaxvalue -- do not set the maximum value
8.
9. nocycle -- always accumulate without repeating
10.
11. cache 10 -- there is a buffer
12.
13.
14.
15. eg create sequence salary_seq
16.
17. Min value 100
18.
19. max value 9999999999
20.
21. start with 560
22.
23. increment by 1
24.
25. cache 20;
26.
27.
28.
29. using: insert into tableName value (salary_seq.nextval ,'','');