Re: strange behaviour of sequence

hi j.p.!

try with

SQL > create sequence testseq start with 1 NOCACHE ORDER;

regards
daniel

oraora oraora wrote:
>
> Guys,
>
> one of my developers is using sequence to auto-increment the value
> of a column while inserting.
>
> he has created a sequence like this.
>
> SQL > create sequence testseq start with 1;
>
> and then uses a INSERT statement as below in a JSP.
>
> insert into testtab values ('BREAD'||testseq.nextval);
>
> after some inserts .....when he does SELECT from TESTTAB...he
> finds
> the values as :
>
> BREAD1
> BREAD2
> BREAD3
> BREAD4
> BREAD21
> BREAD22
>
> it should increment by 1.but it is not so ?
>
> any hint/clue ????
>
> Regards,
> Jp.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Daniel Wisser
  INET: daniel.wisser_at_isis-papyrus.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).