Oracle does not have automatic growth data types, you need to create an automatic sequence number, insert the next one of the serial numbers when inserting records
The value is worthy of this field.
Create sequence serial number name (best is a table name serial number tag) Increment by 1 start with 1
MaxValue 99999 Cycle Nocache;
The largest value is set by the length of the field, and if the defined automatic growth serial number Number (6), the maximum is 99999
Insert statement inserts this field value: the name of the serial number. NexTVal
