(Solved): Write in PL/SQL: write an anonymous block program unit that delete the vendors from vendor_contac ...

Write in PL/SQL:

write an anonymous block program unit that delete the vendors from vendor_contacts table by a user-input vendor_id and print a message 'vendor record has been deleted successfully'. The program raises an exception if there is no vendor_id matches the user-input vendor_id.

Try two test cases:

Vendor_id  : 12

Vendor_id  :  111

Show screenshots of SQL code please!!

VENDOR_CONTACTS ? VENDOR_ID ? LAST_NAME ? FIRST_NAME VENDORS ? VENDOR_ID ? VENDOR_NAME ? VENDOR_ADDRESS1 ? VENDOR_ADDRESS2 ? VENDOR_CITY ? VENDOR_STATE ? VENDOR_ZIP_CODE ? VENDOR_PHONE ? VENDOR_CONTACT_LAST_N ? VENDOR_CONTACT_FIRST_N ? DEFAULT_TERMS_ID ? DEFAULT_ACCOUNT_NUMBE