SyntaxFix
Write A Post
Hire A Developer
Questions
Tags
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.
This question is related to sql database oracle sequence toad
sql
database
oracle
sequence
toad
You may not have permission to dba_sequences. So you can always just do:
select * from user_sequences;
Source: Stackoverflow.com