Advertisement
catalin_stefann11

Untitled

May 21st, 2019
81
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.34 KB | None | 0 0
  1. CREATE OR REPLACE PACKAGE BODY packet IS
  2. PROCEDURE modifica_nr_exemplare
  3. (p_id_carte IN carti.id_carte%TYPE, modificare IN NUMBER)
  4. IS
  5. BEGIN
  6. UPDATE carti
  7. SET nr_exemplare = modificare
  8. WHERE id_carte = p_id_carte;
  9. DBMS_OUTPUT.PUT_LINE('Carte cu id-ul ' ||p_id_carte|| ' are ' ||modificare|| ' de exemplare acum!');
  10. END modifica_nr_exemplare;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement