Advertisement
cristiano002

Untitled

Jun 9th, 2014
245
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. create function
  2. aktualizuj_klienta (id integer, nowa_nazwa, nowy_adres)
  3. return integer is
  4. cursor c is select * from klienci
  5. where id_kl = id;
  6. begin
  7. for var in c loop
  8. if var is NULL then exit; end if;
  9. var.nazwa_kl = nowa_nazwa;
  10. var.nowy_adres = nowy_adres;
  11. end loop;
  12. end;
  13. end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement