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

From: Yee Lew <ylew_at_cc.weber.edu>
Date: 1995/08/28
Message-ID: <28AUG199515472754_at_cc.weber.edu>#1/1

In article <1995Aug28.185301.22691_at_media.mit.edu>, Yezdi Lashkari <yezdi> writes.. [snip]

How about: SELECT your_sequence_name.CURRVAL

FROM dual;

This gets you the current value in the sequence or the start value in the sequence if the sequence has not been used.

Regards,

Yee
Oracle Consultant Received on Mon Aug 28 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Saad Ahmad: "Re: How do I determine the start number in a sequence from SQL ?"
Previous message: Yezdi Lashkari: "How do I determine the start number in a sequence from SQL ?"
In reply to: Yezdi Lashkari: "How do I determine the start number in a sequence from SQL ?"
Next in thread: Saad Ahmad: "Re: How do I determine the start number in a sequence from SQL ?"
Reply: Saad Ahmad: "Re: How do I determine the start number in a sequence from SQL ?"
Reply: Don Smith: "Re: How do I determine the start number in a sequence from SQL ?"
Reply: YourNameHere: "Re: How do I determine the start number in a sequence from SQL ?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message