Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE
- v_exemplare NUMBER(3);
- i NUMBER := 400;
- BEGIN
- LOOP
- SELECT nr_exemplare INTO v_exemplare FROM carti WHERE id_carte = i;
- EXIT WHEN i > 900 OR v_exemplare > 250;
- DBMS_OUTPUT.put_line('Cartea cu id-ul '||i||' are '|| v_exemplare || ' exemplare.');
- i:= i + 111;
- END LOOP;
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement