Modeling Oracle Sequences

[Payton_Byrd]

What is the appropriate technique for modeling an Oracle Sequence?  This is the one topic I can't find in the help files.

[jtittler]

Whenever I've done an Oracle sequence, it's usually for an ID field in a table somewhere, which serves as the primary key. If you open up the Attributes of the table in question and select the column which is supposed to be sequenced, you then click the "Column Properties..." button. There you can check auto-number enter the starting number and the increment size. I know that creates an appropriate oracle sequence and associates it with the field automatically. That's convenient.

Good Luck,
Julie