Encrement Sequence

[jerry-sc]

Hello everyone,

I need to develop a procedure, which will need to use the next value of a sequence. Someone knows how to do this via SQL for:
1) Catch the NextVal of Sequence
2) Increase the value of sequence to

Thanks!

[tiago_pimenta]

Creates a sequence.

and then to pick up, just use the Select below.

Select all

select sequence.nextval into sua_variavel from dual

Every time you run the SELECT above, it increments if Sequence.

[vitellozzi]

Creating and increasing Sequence:

Creating an initial sequence 1:

Select all

CREATE SEQUENCE SEQ_TESTE START WITH 1;

Next value of a sequence:

Select all

SELECT SEQ_TESTE.NEXTVAL FROM DUAL;

[[99 ]
Excluding sequence:

Select all

DROP SEQUENCE SEQ_TESTE;

Creating a sequence starting from 100

Select all

CREATE SEQUENCE SEQ_TESTE START WITH 100;

Changing the value maximum sequence and increasing:

Select all

ALTER SEQUENCE SEQ_TESTE MAXVALUE 99999 INCREMENT BY 1 NOCYCLE NOCACHE;

no longer,

Daniel Vitellozzi