aspose file tools*
The moose likes Oracle/OAS and the fly likes list of sequences Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Bookmark "list of sequences" Watch "list of sequences" New topic
Author

list of sequences

vivek ja
Ranch Hand

Joined: Feb 24, 2005
Posts: 80
Hi,

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

Thanks,

Vivek
Jeanne Boyarsky
internet detective
Marshal

Joined: May 26, 2003
Posts: 29287
    
140

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?


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
Pho Tek
Ranch Hand

Joined: Nov 05, 2000
Posts: 761

select * from user_sequences
Jigar Patel
Greenhorn

Joined: Sep 15, 2009
Posts: 7
If you want to find all Sequence in Data base use
select * from all_sequences;
Vinod Tiwari
Ranch Hand

Joined: Feb 06, 2008
Posts: 459
    
    1


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


Vinod Tiwari | Twitter
Martin Vajsar
Sheriff

Joined: Aug 22, 2010
Posts: 3454
    
  47

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.
 
wood burning stoves
 
subject: list of sequences
 
Similar Threads
quotes that I want in arguments to main
sequence creation
char doubt
Why cannot declare char c = '\u000a'
Force a string to ignore meta characters