allsequences

Syntax

allsequences [[owner_name_pattern.] table_name_pattern]

Description

Lists, in a single column, the names of all the sequences that match the given pattern selected from SYS.ALL_OBJECTS. When a pattern is missing, the pattern defaults to "%".

If passthrough is enabled, lists sequences on tables matching the pattern in the Oracle database.

For more details, see List Database Objects by Object Type.

Examples

Command> allsequences;
  SYS.OBJECTSEQUENCE
  SYS.OBJECT_GRANT
  SYS.PROFNUM$
  SYS.SPID
  SYS.SYSTEM_GRANT
  SYS.USERSEQUENCE
6 sequences found.