Re: Clarification on Oracle sequences

But Start With
"specifies the first sequence number to be generated. You can use this option to start an ascending sequence at a value greater than its minimum or to start a descending sequence at a value less than its maximum. For ascending sequences, the default value is the sequence's minimum value. For descending sequences, the default value is the sequence's maximum value."

Interesting...

Rajesh Bhave (rajeshb_at_india.hp.com) wrote:
: Hello Oracle gurus,

: Any takers for this question posted 2nd time :
: Oracle manual mentions that sequence MAXVALUE must be equal to or less
: than START WITH and must be
: greater than MINVALUE. (Oracle8 manual also mentions same). Should not
: the MAXVALUE be greater or
: equal to START WITH and greater that MINVALUE ? Is it wrongly mentioned
: in Oracle documentation. Please
: clarify.

: Thanks in advance and Regards,
: Rajesh Bhave
: Consultant in HP-India Software Operations

-- Received on Fri Nov 06 1998 - 17:05:35 CST