Home > Articles > Data > Oracle

  • Print
  • + Share This
From the author of

Associated Issues

With this much variation in autonumbering, be prepared to do some work when you move from system to system. Check your documentation for information in these areas:

  • Specifying datatypes and other column properties (null/not null, for example)

  • Setting the start number and increment value

  • Relating the sequence element to table constraints and indexes

  • Locating the current highest number

  • Creating ranges or maximums

  • Dealing with DELETEs and UPDATEs (reuse the number or leave a gap?)

  • Overriding autonumbering

Most SQL engines have a rich set of tools to manage the sequential numbers.

  • + Share This
  • 🔖 Save To Your Account