Advertisement
Guest User

Untitled

a guest
Feb 5th, 2019
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.36 KB | None | 0 0
  1. CREATE OR REPLACE PROCEDURE asdasd(liczba NUMBER, waga VARCHAR2)
  2. AS
  3. BEGIN
  4.     IF (waga = 0) THEN
  5.         UPDATE produkty
  6.         SET produkty.cena = produkty.cena + produkty.cena*(1.0*liczba/100);
  7.     ELSE
  8.         UPDATE produkty
  9.         SET produkty.cena = produkty.cena + produkty.cena*(1.0*liczba/100)
  10.         WHERE produkty.waga > waga;
  11.     END IF;
  12. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement