Sequence increment script



ALTER SEQUENCE ELODBA05.ISEQ$$_1258878 INCREMENT BY 1273374;

for
SELECT ELODBA05.ISEQ$$_1285385.NEXTVAL FROM dual;

2313357
1867453


BR_BRWR_SEQ

ALTER SEQUENCE ELODBA06.BR_BRWR_SEQ INCREMENT BY 1273374;


DECLARE
   a number(10);
   b number(10); 
BEGIN
   FOR a in 482399154 .. 488664116 LOOP
      SELECT ELODBA06.BR_BRWR_SEQ.NEXTVAL into b FROM dual;
  dbms_output.put_line('value of b: ' || b);
  END LOOP;
END;
/

No comments:

Post a Comment