CODEWITHSUNDEEP
oracle-databaseplsqlsequence
praveen
praveen

Reputation: 27

how to generate sequence number in plsql in a cyclic way

I want to generate sequence number from 91 to 100 using oracle plsql code and if my sequence reaches 100 next value should be 91 again .

Please help

Upvotes: 1

Views: 368

Answers (1)

Littlefoot
Littlefoot

Reputation: 142720

Ummm ... no. That's not a PL/SQL issue. You should generate a sequence that does what you described:

create sequence seq_ng minvalue 91 maxvalue 100 cycle nocache;

SQL> create sequence seq_ng minvalue 91 maxvalue 100 cycle nocache;

Sequence created.

SQL> select seq_ng.nextval from dual;

   NEXTVAL
----------
        91

SQL> select seq_ng.nextval from dual;

   NEXTVAL
----------
        92

<snip>

SQL> select seq_ng.nextval from dual;

   NEXTVAL
----------
       100

SQL> select seq_ng.nextval from dual;

   NEXTVAL
----------
        91              --> it starts over again

SQL>

Upvotes: 2

Related Questions