If your database does not use native sequencing, you must manually create the sequence table (named SEQUENCE). Use this table to store each table, as illustrated below:
| Field Name | Field Format | Description |
|---|---|---|
| SEQ_NAME | CHAR | Name of the sequence number |
| SEQ_COUNT | NUMERIC | Current value |
After creating the table, you must initialize the table within the application. The value of the SEQ_COUNT field for each sequence should be zero (0), as in the following table.
| SEQ_NAME | SEQ_COUNT |
|---|---|
| EMP_SEQ | 0 |
| PROJ_SEQ | 0 |
Copyright © 1997, 2004, Oracle. All rights reserved.