A sequence report lists the sequence's:

  • Name
  • Initial value
  • Incremental value
  • Maximum and minimum value

It also indicates whether the sequence should cycle, and if connected to a multi-tenant database, if the sequence is a multi-tenant sequence.

To generate a sequence report:

  1. Make sure that the working database is the target database for which you want to generate the report.
  2. Choose Database > Reports > Sequence. The Sequence Report dialog box appears and displays information about all sequences defined for the working database.
  3. Choose Print if you want to print the report. The Print Options dialog box appears.
  4. Specify the report destination. If you want to save the report to a file, specify the filename and whether to append the report to an existing file.
  5. Specify the page length, then choose OK. The Data Dictionary sends the report to the specified output destination and returns you to the Sequence Report dialog box.
  6. Choose OK to return to the Data Dictionary main window.