Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- CURSOR cur_sveucilista IS
- SELECT *
- FROM fakulteti;
- redak cur_sveucilista%ROWTYPE;
- BEGIN
- OPEN cur_sveucilista;
- LOOP
- FETCH cur_sveucilista INTO redak;
- EXIT WHEN cur_sveucilista%NOTFOUND;
- IF UPPER(redak.naziv) LIKE UPPER('%sve%') THEN
- IF EXTRACT(YEAR FROM SYSDATE) - EXTRACT(YEAR FROM redak.datum_otvaranja) < 10 THEN
- UPDATE fakulteti
- SET sveuèilište = 1
- WHERE redak.id_fakulteta = id_fakulteta;
- ELSE
- UPDATE fakulteti
- SET sveuèilište = 0
- WHERE redak.id_fakulteta = id_fakulteta;
- END IF;
- ELSE
- UPDATE fakulteti
- SET sveuèilište = 0
- WHERE redak.id_fakulteta = id_fakulteta;
- END IF;
- END LOOP;
- EXCEPTION
- WHEN OTHERS THEN
- DBMS_OUTPUT.put_line('Greška !');
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement