21 Aralık 2011 Çarşamba

Increase sequence value

--add 1000 to sequence current value

DECLARE
   i   NUMBER;
   a   NUMBER;
BEGIN
   FOR i IN 1 .. 1000
   LOOP
      SELECT appuser.sq_fisno.NEXTVAL
        INTO a
        FROM DUAL;
   END LOOP;
END;

Hiç yorum yok:

Yorum Gönder