How can I get all sequences in an Oracle database?

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.

sql
database
oracle
sequence
toad

194711 次浏览

小开

最佳答案

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 USER_SEQUENCES.

小开

You may not have permission to dba_sequences. So you can always just do:

select * from user_sequences;