PHY PHYS_NAME            PHYS_PHONE   PHYS_SPECIALTY
--- -------------------- ------------ --------------------
101 Wilcox, Chris        512-329-1848 Eyes, Ears, Throat
102 Nusca, Jane          512-516-3947 Cardiovascular
103 Gomez, Juan          512-382-4947 Orthopedics

SQL> SET SERVEROUTPUT on
SQL> DECLARE
  2    v_Physician  Physician%ROWTYPE;
  3    v_Phys_ID  Physician.Phys_ID%TYPE := &v_Phys_ID;
  4    v_Phys_Name  Physician.Phys_Name%TYPE;
  5    v_Phys_Phone  Physician.Phys_Phone%TYPE;
  6    v_Phys_Specialty  Physician.Phys_Specialty%TYPE;
  7    v_err_code NUMBER;
  8    v_err_msg VARCHAR2(200);
  9  BEGIN
 10    SELECT *
 11    INTO v_Physician
 12    FROM Physician
 13    WHERE Phys_ID = v_Phys_ID;
 14    IF SQL%FOUND THEN
 15      UPDATE Physicians
 16        SET Phys_Name = '&v_Phys_Name',
 17            Phys_Phone = '&v_Phys_Phone',
 18            Phys_Specialty = '&v_Phys_Specialty'
 19        WHERE Phys_ID = v_Physician.Phys_ID;
 20    END IF;
 21  EXCEPTION
 22    WHEN NO_DATA_FOUND THEN
 23      INSERT INTO Physicians
 24
 25  VALUES('&v_Phys_ID','&v_Phys_Name','&v_Phys_Phone','&v_Phys_Specialty');
 26    WHEN OTHERS THEN
 27      v_err_code := SQLCODE;
 28      v_err_msg := SUBSTR(SQLERRM, 1, 200);
 29      DBMS_OUTPUT.PUT_LINE('Error code: '||v_err_code);
 30      DBMS_OUTPUT.PUT_LINE('Error message: '||v_err_msg);
 31  END;
 32  /
Enter value for v_phys_id: 105
old   3:   v_Phys_ID  Physician.Phys_ID%TYPE := &v_Phys_ID;
new   3:   v_Phys_ID  Physician.Phys_ID%TYPE := 105;
Enter value for v_phys_name:
old  16:       SET Phys_Name = '&v_Phys_Name',
new  16:       SET Phys_Name = '',
Enter value for v_phys_phone:
old  17:           Phys_Phone = '&v_Phys_Phone',
new  17:           Phys_Phone = '',
Enter value for v_phys_specialty:
old  18:           Phys_Specialty = '&v_Phys_Specialty'
new  18:           Phys_Specialty = ''
Enter value for v_phys_id: 105
Enter value for v_phys_name: Richard, Casino
Enter value for v_phys_phone: 214-412-1234
Enter value for v_phys_specialty: Black jack
old  25: VALUES('&v_Phys_ID','&v_Phys_Name','&v_Phys_Phone','&v_Phys_Specialty')
;
new  25: VALUES('105','Richard, Casino','214-412-1234','Black jack');

PL/SQL procedure successfully completed.

SQL> select * from physicians;

PHY PHYS_NAME            PHYS_PHONE   PHYS_SPECIALTY
--- -------------------- ------------ --------------------
101 Wilcox, Chris        512-329-1848 Eyes, Ears, Throat
102 Palace, Buffet       222-111-1234 spicy food
103 Gomez, Juan          512-382-4947 Orthopedics
105 Richard, Casino      214-412-1234 Black jack

14    IF SQL%FOUND THEN
 15      UPDATE Physicians
 16        SET Phys_Name = '&v_Phys_Name',
 17            Phys_Phone = '&v_Phys_Phone',
 18            Phys_Specialty = '&v_Phys_Specialty'
 19        WHERE Phys_ID = v_Physician.Phys_ID;
 20    END IF;