Re: How do I determine the start number in a sequence from SQL ?

Yezdi Lashkari (yezdi) wrote:
: Hi,
: I'm trying to write Pro*C code to determine the
: starting number in an Oracle sequence. Is there
: any SQLPLUS / Pro*C statement that can tell me
: what the start ID for that Sequence is (the
: one used in the CREATE SEQUENCE command) ?
 

: Please reply to me directly.
 

: thanks
: Yezdi
 

: (yezdi_at_agents-inc.com)

Try this,

select min_value from user_sequences where

        sequence_name = your_sequence_name;

I hope this helps.

regards
nathan

nathan_at_parcom.ernet.in Received on Wed Aug 30 1995 - 00:00:00 CEST