Advertisement
Guest User

Untitled

a guest
May 21st, 2019
67
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.26 KB | None | 0 0
  1.  
  2. DECLARE
  3. v_nume editura.nume_editura%TYPE;
  4.  
  5. BEGIN
  6. SELECT nume_editura INTO v_nume
  7. FROM editura
  8. WHERE id_editura = 10;
  9. DBMS_OUTPUT.put_line(v_nume);
  10.  
  11. EXCEPTION
  12. WHEN NO_DATA_FOUND THEN
  13. DBMS_OUTPUT.put_line('Nu exista editura cu acest ID!');
  14.  
  15. END;
  16. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement