Re: Sequences: newbie question

From: Wyatt Underwood <underwd_at_ibm.net>
Date: 1997/06/05
Message-ID: <3396a6a8.0@news1.ibm.net>#1/1

Another newbie asked
>
> What's the command to call up a list of sequences I've created on my
> tables?
>
> Where is this list stored?
>
> Thanks for your help!
>

Assuming this limb will hold me up, <g> let me guess that you've a more-or-less hidden table called User_Sequences, and that

desc user_sequences
will list its fields - one of which holds the names of the sequences.

Then

select sequence_names from user_sequences ; will list the names of your sequences for you - don't forget the semi-colon ending the second command and don't include it on the first.

Good luck,

Wyatt Underwood
wyatt.underwood_at_ibm.net
ai644_at_lafn.org
http://www.geocities.com/Athens/2639 Received on Thu Jun 05 1997 - 00:00:00 CDT