Re: sequence question

all that was said is true, u can do a
select max(PK) +1
from table_name

that would give u always a sequence.... :)

leandro

"Sudarshan Sampath" <ssampath_at_scr.siemens.com> wrote in message news:hG4_6.11146$DW1.462722_at_iad-read.news.verio.net...
> This question is more to clarify the concept of a sequence.
>
> Say I have a table MYTABLE with column (PK NUMBER(10)) filled with
> rows in the range 10000 - 20000.
>
> I have a sequence that I create with the following params:
>
> Start With = 10000
> Increment by = 1
> Cache = 20
> Min Value = 10000
> Max Value = None
>
> Let's call this sequence MYSEQ.
>
> Now, if I referenced this sequence in my application with (MYSEQ.NEXTVAL)
 to
> insert
> a row in the table MYTABLE, would it give me a value 20001?
>
> insert into MYTABLE (PK)
> values
> (MYSEQ.NEXTVAL);
>
> Would this insert a new row with PK = 20001? Or would it give me an error
> till the sequence value
> is incremented until 20001? Does a primary key implicitly mean that the
> sequence we use against it
> will return a unique value for that table?
>
> I am merely trying to understand how the sequence works.
>
> Thanks,
>
> -Sudarshan
>
>
Received on Wed Jul 25 2001 - 21:44:15 CDT