Re: Sequence ID view??

"Thomas Glynn Smith" <glynn_at_excalibur.net> wrote:
>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

Hi there,

Try the following statement

select * from user_sequences

Good Luck,

N.Prabhakar
Socgen Crosby Securities
Singapore

Email : prabhs_at_pacific.net.sg Received on Thu Nov 14 1996 - 00:00:00 CET