Create, modify, and delete an Oracle database sequence.

Create, modify, and delete an Oracle database sequence.

1. Create a sequence

1.1 create a sequence: create sequence seqtest;

1.2 query the current Sequence Value: select seqtest. currval from dual;

1.3 next value of the query sequence: select seqtest. nextval from dual;

1.4 create a sequence with an initial value of 1, an increment of 1, and a loop | non-repeating:

Create sequence testseq increment by 1 start with 1 maxvalue 99 cycle | nocycle;

2. Modify the sequence

Alter sequence testseq minvalue 0 | maxvalue 15;

3. Delete Sequence

Drop sequence testseq;