Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ACCEPT id_m PROMPT 'Introduceti id-ul membrului'
- DECLARE
- invalid_id EXCEPTION;
- id_mem membrii.id_membru%TYPE := &id_m;
- BEGIN
- UPDATE membrii
- SET nr_telefon = NULL
- WHERE id_membru = id_mem;
- IF SQL%NOTFOUND THEN
- RAISE invalid_id;
- END IF;
- EXCEPTION
- WHEN invalid_id THEN
- DBMS_OUTPUT.PUT_LINE('Nu exista membrul cu id-ul: ' || id_mem);
- END;
- /
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement