Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

list of sequences

 
vivek ja
Ranch Hand
Posts: 80
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

How can I find the names of all the sequences in a database?

Thanks,

Vivek
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 34095
337
Eclipse IDE Java VI Editor
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Vivek,
I'm not sure if this would work, but could you try querying the user_objects table for the object_type that represents a sequence?
 
Pho Tek
Ranch Hand
Posts: 782
Chrome Python Ubuntu
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
select * from user_sequences
 
Jigar Patel
Greenhorn
Posts: 7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
If you want to find all Sequence in Data base use
select * from all_sequences;
 
Vinod Tiwari
Ranch Hand
Posts: 466
1
IntelliJ IDE Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Above query would only work if your user has select access on the table else you need to check with your DBA.
 
Martin Vajsar
Sheriff
Pie
Posts: 3751
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Vinod Tiwari wrote:

Above query would only work if your user has select access on the table else you need to check with your DBA.

By default, users have access to the USER_XXX and ALL_XXX data dictionary views. These views contains information about objects the user owns or has been granted access to, and they are vital for many functions (including Oracle's implementation of the JDBC mechanism for obtaining metadata information), so I doubt they would be unavailable in any Oracle database.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic