Bài đăng phổ biến

4/17/2019

Increase sequence in Oracle use DML

Increase sequence  to  120000 as below:

DECLARE
i NUMBER;
BEGIN
LOOP
select aupv06.SEQ_NAME.nextval
into i
from dual;
EXIT WHEN i >= 120000;
END LOOP;
END;

select aupv06.SEQ_NAME.nextval from dual;

0 comments:

Đăng nhận xét