Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Clarification on Oracle sequences
I think your are referring to the SQL manual. It appears to be a
misstatement. By reading the 'start with' and 'minvalue' causes you can
pretty much figure out what 'maxvalue' should read, i.e., max > min and
'start with' must fall within an inclusive between of the two values. By
inclusive I mean the min and max values are valid 'start with' values. I
hope this is clear and helps.
Rajesh Bhave <rajeshb_at_india.hp.com> wrote in article
<3642C4EE.C114AA20_at_india.hp.com>...
> 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 - 12:41:09 CST