INSERT INTO person (id, lastname, firstname, mi, street, city, state,
                    zip, area_code, phone_number)
       (SELECT 9999, 'Striker', 'Joan', 'R', street, city, state,
               zip, area_code, phone_number
          FROM person
         WHERE id=7881)
/
