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.