Here is a video tutorial to explain about exception handling in PL/SQL. Material is taken from https://plsql-tutorial.com/plsql-exception-handling.htm. (Recorded with https://screencast-o-matic.com)
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.