Advertisement
Guest User

Untitled

a guest
Jun 22nd, 2017
279
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.37 KB | None | 0 0
  1. DECLARE
  2.     startSeq INTEGER;
  3.     endSeq INTEGER;
  4. BEGIN
  5.     SELECT MAX(id_ocena) + 1 INTO startSeq FROM ocena;
  6.     endSeq := startSeq + 1000;
  7. --  execute immediate 'create sequence zad6_3seq start with ' || startSeq || ' increment by 1 maxvalue ' || endSeq;
  8.     EXECUTE IMMEDIATE 'create sequence zad6_3seq start with :start_ increment by 1 maxvalue :end_' using IN startSeq, endSeq;
  9. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement