Advertisement
Guest User

Untitled

a guest
May 21st, 2019
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.29 KB | None | 0 0
  1. DECLARE
  2. v_exemplare NUMBER(3);
  3. i NUMBER := 400;
  4. BEGIN
  5. LOOP
  6. SELECT nr_exemplare INTO v_exemplare FROM carti WHERE id_carte = i;
  7. EXIT WHEN i > 900 OR v_exemplare > 250;
  8. DBMS_OUTPUT.put_line('Cartea cu id-ul '||i||' are '|| v_exemplare || ' exemplare.');
  9. i:= i + 111;
  10. END LOOP;
  11. END;
  12. /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement