Re: Sequence ID view??

From: <mlanda_at_vnet.ibm.com>
Date: 1996/11/13
Message-ID: <56d8va$f5t_at_watnews1.watson.ibm.com>#1/1


In <01bbd177$be13c260$d6a79ace_at_glynn-home>, "Thomas Glynn Smith" <glynn_at_excalibur.net> writes:
>Hello,
> I am trying to view all Sequences available but I am having problems. I
>can use the sequences
>by using a sequence that I know exists by using .nextval and .currval. I
>have tried using:
>Select * from sequences;
>
>but it reports view does not exist. Counld anyone help me out?
>
>Thanks in advance.
>
>Glynn Smith
>glynn_at_excalibur.net

If you have a DBA account take a look at view dba_sequences. If not a dba account, look at user_sequences.

M.Landa Received on Wed Nov 13 1996 - 00:00:00 CET

Original text of this message