Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- --2
- DECLARE
- l_ime studenti.ime%type;
- l_prezime studenti.prezime%type;
- BEGIN
- SELECT
- ime,
- prezime
- INTO
- l_ime,
- l_prezime
- FROM
- STUDENTI
- WHERE
- ID=2;
- IF SQL%FOUND
- THEN
- dbms_output.put_line(l_ime ||' '|| l_prezime);
- END IF;
- END;
- --3.
- DECLARE
- l_ime studenti.ime%type;
- l_prezime studenti.prezime%type;
- BEGIN
- SELECT
- ime,
- prezime
- INTO
- l_ime,
- l_prezime
- FROM
- STUDENTI
- WHERE
- ID=3;
- IF SQL%FOUND THEN
- dbms_output.put_line(SQL%ROWCOUNT);
- dbms_output.put_line(l_ime ||' '|| l_prezime);
- END IF;
- END;
- --4.
- BEGIN
- UPDATE
- STUDENTI
- SET
- ime='Kristijan'
- WHERE
- id=2;
- IF SQL%FOUND THEN
- dbms_output.put_line('redak upadetan');
- END IF;
- END;
- SELECT * FROM STUDENTI
- commit;
- rollback;
- --5.
- BEGIN
- UPDATE
- AUTOBUSI
- SET
- CIJENA=CIJENA+5
- WHERE
- id=id;
- IF SQL%FOUND THEN
- dbms_output.put_line('Promjenjeno');
- END IF;
- END;
- --6.
- DECLARE
- CURSOS
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement