Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE PROCEDURE test_dostawa(p_nazwa IN VARCHAR(50), p_ilosc IN NUMBER(10)) IS
- v_count NUMBER(10);
- BEGIN
- SELECT COUNT(nazwa) INTO v_count FROM towar WHERE nazwa = p_nazwa;
- IF (v_count > 0) THEN
- UPDATE towar SET ilosc = p_ilosc WHERE nazwa = p_nazwa;
- ELSIF
- INSERT INTO towar (nazwa, ilosc) VALUES p_nazwa, p_ilosc;
- END;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement