A sequence generation rule is a global or ad hoc rule that generates numeric and date values in a sequence.
You select a beginning value and an increment value when you create a sequence generation rule.
Sequence generation rules can be global rules or ad hoc rules.
The following image shows the sequence generation parameters:
Sequence Generation Example
You want to generate ticket numbers in ascending order. The target table has a TICKET_NUMBER column. You create a sequence generation rule with the numeric data type. You enter a start value of 1000 and an increment value of one (1).