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

In article <1995Aug28.185301.22691_at_media.mit.edu> Yezdi Lashkari <yezdi> writes:
>From: Yezdi Lashkari <yezdi>
>Subject: How do I determine the start number in a sequence from SQL ?
>Date: Mon, 28 Aug 1995 18:53:01 GMT
 

>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

I believe the min_value column of the dba_sequences view is what you are looking for.

Sandra Rennick
Independent Contractor

>(yezdi_at_agents-inc.com)
Received on Tue Aug 29 1995 - 00:00:00 CEST