Re: Sequence ID view??
From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/11/14
Message-ID: <56fakd$log_at_newton.pacific.net.sg>#1/1
Date: 1996/11/14
Message-ID: <56fakd$log_at_newton.pacific.net.sg>#1/1
"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
Try using USER_SEQUENCES
select * from user_sequences
Regards
N.Prabhakar Received on Thu Nov 14 1996 - 00:00:00 CET