Re: SQL to find all Sequences in Schema

Tom Schindl wrote on 04.03.2006 23:44:
> Hi Michel,
>
> thanks for the fast answer but I can't follow you. My problem is not to
> find the Sequences known into a database using an Oracle Utility i need
> them to fetch in an Java-Application to shown them to the user.
>
> Is your comment refering to EM or do I misinterpret your message, if
> that's the case could elaborate a little bit more?
>

What he meant:

SELECT * FROM all_sequences;
or
SELECT * FROM dba_sequences;
or
SELECT * FROM user_sequences;

These views are all documented in the Oracle manual.

Thomas Received on Sat Mar 04 2006 - 15:50:01 CST