Advertisement
Guest User

Untitled

a guest
Apr 23rd, 2018
55
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.28 KB | None | 0 0
  1. DECLARE
  2. cursor c1 is SELECT ZDAL from EGZAMINY for update of punkty;
  3. begin
  4. for data in c1 loop
  5. if data.zdal='Y' then
  6. update egzaminy set punkty=ROUND(SYS.DBMS_RANDOM.VALUE(3,5), 2) where current of c1;
  7. else
  8. update egzaminy set punkty=2 where current of c1;
  9. end if;
  10. end loop;
  11. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement