Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create function
- aktualizuj_klienta (id integer, nowa_nazwa, nowy_adres)
- return integer is
- cursor c is select * from klienci
- where id_kl = id;
- begin
- for var in c loop
- if var is NULL then exit; end if;
- var.nazwa_kl = nowa_nazwa;
- var.nowy_adres = nowy_adres;
- end loop;
- end;
- end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement