Oracle has no self-intensive field
The following is a solution, but the problem is that this self-increment is a limited self-increasing.
Spend:
Create sequence seq_name
INCREMENT BY 1
START WITH 1
MaxValue 999999;
INSERT INTO TABLE_NAME (ID, ...) VALUES (seq_name.nextval, ...)
