Is there any command that I can run so that I can get all the sequences?
I am using Oracle 11g. I am using Toad for Oracle to connect to it. I can visually see the sequences in Toad, but I like to know the command line for it.
select sequence_owner, sequence_name from dba_sequences; DBA_SEQUENCES -- all sequences that exist ALL_SEQUENCES -- all sequences that you have permission to see USER_SEQUENCES -- all sequences that you own
Note that since you are, by definition, the owner of all the sequences returned from
USER_SEQUENCES, there is no
SEQUENCE_OWNER column in