Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- cursor c1 is SELECT ZDAL from EGZAMINY for update of punkty;
- begin
- for data in c1 loop
- if data.zdal='Y' then
- update egzaminy set punkty=ROUND(SYS.DBMS_RANDOM.VALUE(3,5), 2) where current of c1;
- else
- update egzaminy set punkty=2 where current of c1;
- end if;
- end loop;
- end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement