ORACLE - UPDATE SEQUENCE VALUE USING LOOP

 DECLARE  l_counter NUMBER := 0;

t NUMBER:=0;

BEGIN

LOOP

    l_counter := l_counter + 1;

    IF l_counter > 32690 THEN

      EXIT;

    END IF;

    SELECT ISEQ$$_832661.nextval INTO t from dual;

  END LOOP;

END;

0 comments:

 
Copyright © peyotest